Charting Inverted Rates

Jesusismygrace

New Member
Joined
Jul 27, 2011
Messages
3
I am not sure how to properly word this nor the proper terms, so forgive me.</SPAN>
I have a set of rates that I would like to track over a three year period and chart them against various industry benchmarks. The rates are inverted, the lower the rate the better, so if our rate was 45% and the benchmark was 35%, the benchmark would be performing better than us. My confusion is how to visual display this with charts. Currently, I have bar graphs that represent our rates and line graphs that represent the various benchmarks compared to our rates. Because all the benchmarks are performing better than our rates, the lines are charting in the body of the bar graphs.</SPAN>
Is there a solution for display data in this format? </SPAN>
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
You could start easy by plotting 2 line charts: the one above the other is worse (45 % worse than 35 %).

High-low lines could be plotted automatically to indicate visually the difference between the 2 lines, for each point on the horizontal axis.
 
Upvote 0

Forum statistics

Threads
1,224,505
Messages
6,179,147
Members
452,891
Latest member
JUSTOUTOFMYREACH

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top