View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Bar chart - horizontal bars

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
_______


"Unhappy" wrote in message
...
All Excel versions I know are very good at making bar charts (I mean those
charts in which the bars are horizontal). But the problem is that the
X-axis
is at the bottom, and items for the Y-axis are placed in reverse order as
desirable (for example, first item in the series is placed at the bottom
-close to the X-axis, last item in the series is placed first from the top
-far from the X-axis). I don't know if I'm making myself clear, posting a
picture would be more easier but it's impossible. Anyway, my question: Is
there any way to:

1-Place the X-axis at the top.
2- Avoid Excel to invert the order of items (ideal order would be: first
item at the top, last item at the bottom).
Thanks.