Horizonal bar chart with secondary axis problem

[BZ]

I have 3 columns, one is labels and other others are data. when I create a
horizonal bar chart, the order of the data is reversed; no, I don't know why.
I am diosplaying the data on 2 different axes since they have different
scales. When I reverse the order of the labels in the vertical axis format
window, only the data on the primary axis is also reversed--the data on the
seconary axis remains in the original (incorrect) order.

I need the table in the spredsheet and the chart to display in the same
order. Any solutions/suggestions?

 

[Jon Peltier]

The data isn't reversed in the chart, it is plotted starting at the origin,
which is the bottom left corner, so they start at the bottom and proceed
upward. Of course, this isn't what we expect, so we change it ourselves.

I wonder if you have a secondary category axis which needs to be reversed
the same way you did the primary one. On the dialog to format the secondary
value axis, look where you can set the crossing point of the category axis.
Choose Crosses at Maximum Value. Now you can see the axis, so you can format
it. Then change the Crosses At setting to what it had been.

- Jon
-------
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html

Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______