Order of Category in X-axis

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good day everybody,

I have a chart looks like this :
A3 |
A2 |
A1 |
-------|-------------------

I would like it to be like this :
A1 |
A2 |
A3 |
-------|-------------------

I remember I can reverse my Category in X-axis by clicking a reverse option
when I used Excel 2000. But now I couldn't do the same with Excel 2002.

I will appreciate if someone can help me.

Thanks in advance.

Best regards,
Julie
 
Julie -

Double click the axis, click on the Scale tab, and check the Categories
(or Values) in Reverse Order box. You probably also will want to check
the Axis Crosses at Maximum box.

These have been available since the first version of Excel I can
remember using, a dozen years ago, and remain available through 2003.

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

What you missed was sentence two of my first paragraph:

"You probably also will want to check the Axis Crosses at Maximum box."

The maximum is now at the bottom, so this will turn around your chart.

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