Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
BZ BZ is offline
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
secondary axis problem raventroll Excel Discussion (Misc queries) 3 May 22nd 08 04:05 PM
secondary axis problem with toolbar Paula New Users to Excel 0 October 10th 06 12:23 PM
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? Dmitry Excel Discussion (Misc queries) 3 May 4th 06 01:58 AM
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? Dmitry Charts and Charting in Excel 2 May 4th 06 01:58 AM
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM


All times are GMT +1. The time now is 05:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"