Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Horizonal bar chart with secondary axis problem
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? -- Barry |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Horizonal bar chart with secondary axis problem
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...00906ACNJ.html Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "BZ" wrote in message ... 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? -- Barry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
secondary axis problem | Excel Discussion (Misc queries) | |||
secondary axis problem with toolbar | New Users to Excel | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Excel Discussion (Misc queries) | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel |