If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I show inverse data in a chart?
I want to show a ranking from 1st place thourgh 10th, where 1st place is the
goal. How can I show this on a chart, so that if I am in 9th place, I am 2nd to last place? |
#2
|
|||
|
|||
How do I show inverse data in a chart?
You can reverse the order of an axis: double click on the axis, click on the
Scale tab, and check the appropriate box. Alternatively you could put the value you want to plot in another range on the sheet, and plot that. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "debjocc" wrote in message ... I want to show a ranking from 1st place thourgh 10th, where 1st place is the goal. How can I show this on a chart, so that if I am in 9th place, I am 2nd to last place? |
#3
|
|||
|
|||
How do I show inverse data in a chart?
If I reverse the order, then the bars appear at the top of the chart and head
downward. What I would really like to show, is that 10 is the minimum, so that it appears at the bottom of the chart. If my rank is 7th, I would like to see the bar rising from 10th place to 7th, showing I have 6 more steps to reach number 1. Is this possible without showing the scale as negative? "Jon Peltier" wrote: You can reverse the order of an axis: double click on the axis, click on the Scale tab, and check the appropriate box. Alternatively you could put the value you want to plot in another range on the sheet, and plot that. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "debjocc" wrote in message ... I want to show a ranking from 1st place thourgh 10th, where 1st place is the goal. How can I show this on a chart, so that if I am in 9th place, I am 2nd to last place? |
#4
|
|||
|
|||
How do I show inverse data in a chart?
There's another checkbox near the Plot in Reverse Order, labeled Axis
Crosses at Maximum. Check it. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "debjocc" wrote in message ... If I reverse the order, then the bars appear at the top of the chart and head downward. What I would really like to show, is that 10 is the minimum, so that it appears at the bottom of the chart. If my rank is 7th, I would like to see the bar rising from 10th place to 7th, showing I have 6 more steps to reach number 1. Is this possible without showing the scale as negative? "Jon Peltier" wrote: You can reverse the order of an axis: double click on the axis, click on the Scale tab, and check the appropriate box. Alternatively you could put the value you want to plot in another range on the sheet, and plot that. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "debjocc" wrote in message ... I want to show a ranking from 1st place thourgh 10th, where 1st place is the goal. How can I show this on a chart, so that if I am in 9th place, I am 2nd to last place? |
#5
|
|||
|
|||
How do I show inverse data in a chart?
So that's the secret! (well, not anymore) Thank you!
"Jon Peltier" wrote: There's another checkbox near the Plot in Reverse Order, labeled Axis Crosses at Maximum. Check it. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "debjocc" wrote in message ... If I reverse the order, then the bars appear at the top of the chart and head downward. What I would really like to show, is that 10 is the minimum, so that it appears at the bottom of the chart. If my rank is 7th, I would like to see the bar rising from 10th place to 7th, showing I have 6 more steps to reach number 1. Is this possible without showing the scale as negative? "Jon Peltier" wrote: You can reverse the order of an axis: double click on the axis, click on the Scale tab, and check the appropriate box. Alternatively you could put the value you want to plot in another range on the sheet, and plot that. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "debjocc" wrote in message ... I want to show a ranking from 1st place thourgh 10th, where 1st place is the goal. How can I show this on a chart, so that if I am in 9th place, I am 2nd to last place? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Show all records on a joined query with criteria | Angel | Running & Setting Up Queries | 6 | December 23rd, 2005 04:31 AM |
Excel Macro to Copy & Paste | [email protected] | Worksheet Functions | 0 | December 1st, 2005 01:56 PM |
How do I show range of data in an area chart? | slycke | Charts and Charting | 1 | September 1st, 2005 01:11 PM |
Fan charts | Dean | Charts and Charting | 7 | May 30th, 2005 11:51 AM |
SQL view of messed up action queries | Kendra | Running & Setting Up Queries | 2 | August 31st, 2004 09:53 PM |