View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Chart X-Axis in reverse order!

That's in forward order. The first item is closest to the low point of the
axis (where the Y axis crosses), the second item is one slot further, etc.

Anyway, you can plot forwards or backwards. Right click on the axis, choose
Format Axis, and on the Scale tab (or in Excel 2007 on the first tab), check
Plot Categories in Reverse Order, and probably also check Value Axis Crosses
at Maximum Category.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Joe M." wrote in message
...
I have a horizontal bar chart where the vertical (X) axis is in reverse
order
of the column where they are listed. There are about 30 values in the
X-axis.

i.e. the column is listed:
Apples
Bananas
...
Watermelons

But in the x-axis it's listed in decending order (Watermelons first,
etc.).
How can I easily change the x-axis to the same order as the column?

Thanks,
Joe M.