Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

DUAL AXES COLUMN CHARTS - possible?

Posted by Karen Erdrich on January 02, 2001 11:34 AM
I have two sets of data. One numbers, one percent. There doesn't apepar to be a function to do dual axis column charts. When I try it, one bar overlays the other. I can't send anyone the file but do you have any suggestions. I've tried EVERYTHING.
Thanks for your time.
Karen

Re: DUAL AXES COLUMN CHARTS - possible?

Posted by Mo on January 02, 2001 1:39 PM

Hello Karen, If I understand what you mean this should help. I got this answer from the office assistant by typing "secondary axis".
Plot a data series along a secondary value axis in a 2-D chart
When the range of values for different data series in a 2-D chart varies widely, or when you have mixed types of data (such as price and volume), you can plot one or more data series on a secondary value (y) axis. The scale of the secondary axis reflects the values for the associated series.

Click the data series you want to plot along a secondary value axis.


On the Format menu, click Selected Data Series, and then click the Axis tab.


Click Secondary axis.
Best of Luck


Re: DUAL AXES COLUMN CHARTS - possible?

Posted by archerrsa on February 14, 2001 2:13 PM

I don't think its possible. Karen is right, there's no such solution for this kind of problem. Excel sucks on this one. Tried everything but to no avail.

I have two sets of data. One numbers, one percent. There doesn't apepar to be a function to do dual axis column charts. When I try it, one bar overlays the other. I can't send anyone the file but do you have any suggestions. I've tried EVERYTHING.


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.