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
|
|||
|
|||
Excel 2003 Charting
I have created a bar chart in Excel 2003 based on a formula that
offers percentages building up from 0% to 100% (akin to a status bar). My problem is that it is showing the lowest percentage bar at the bottom of the graph when it should be at the top (just as my data is showing the lowest percentage at the top building up to 100% at the bottom). How do I change the direction? |
#2
|
|||
|
|||
Excel 2003 Charting
To do so, double-click on the Y-Axis (the category axis). That should bring
up the Format Axis dialog box. Go to the Scale tab and select "Categories in Reverse Order". The X-Axis (value axis) should have moved to the top of the chart now. Double-click on the X-Axis (value axis). The Format Axis dialog box should appear. Go to the Patterns tab and select Tick mark labels = High. -- John Mansfield http://www.cellmatrix.net "Tigger" wrote: I have created a bar chart in Excel 2003 based on a formula that offers percentages building up from 0% to 100% (akin to a status bar). My problem is that it is showing the lowest percentage bar at the bottom of the graph when it should be at the top (just as my data is showing the lowest percentage at the top building up to 100% at the bottom). How do I change the direction? |
#3
|
|||
|
|||
Excel 2003 Charting
In an Excel bar chart, the vertical axis is the X axis (the independent
axis, or the category axis). - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ John Mansfield wrote: To do so, double-click on the Y-Axis (the category axis). That should bring up the Format Axis dialog box. Go to the Scale tab and select "Categories in Reverse Order". The X-Axis (value axis) should have moved to the top of the chart now. Double-click on the X-Axis (value axis). The Format Axis dialog box should appear. Go to the Patterns tab and select Tick mark labels = High. |
Thread Tools | |
Display Modes | |
|
|