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?

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?

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.