What's so hard about "Categories in reverse order"? If you know what the
categories are, this is self-evident.

If it said "Rotate axes", won't most people think that it would switch X and
Y, or rotate the entire chart 90 degrees?

And I don't understand "[an axis] will pull everything attached to it in the
same orientation".

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


"Unhappy" wrote in message
...
Thanks Jon. With Andy's tip, I could easily plot my data. I understand the
X-axis is the independent variable. What's causing difficulty is the
phrasing. For example, the feature called "Catergories in Reverse Order"
should be be called "Rotate axes". Remember that if an axis is truly an
axis,
it will pull everything attached to it in the same orientation. Naming
things
the way people know them adds to functionality. Thanks.


"Jon Peltier" wrote:

Note: the X axis refers to the independent variable, which in a
horizontal
bar chart is the vertical axis. The Y axis is the horizontal axis. When
you
understand this you will have a better understanding of charts,
especially
Excel charts.

Also note that items are listed in order starting at the origin. If your
categories are A, B, C, then they are listed A, B, C in order from the
intersection of the X and Y axes. Since the Y axis is at the bottom, it
seems upside down, but there is a logic to their order. When this logic
is
understood, the behavior is no longer strange.

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