MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Column Chart with 2 axes


Posted by Eric on February 04, 2002 6:29 PM

Is it possible to create a column chart using two seperate axis? I don't want to use the Column/Line graph with 2 axes, I want there two be two columns, one to be plotted against the primary axis and another column to be plotted against the secondary axis. Can anyone help? Thanks in advance.

-Eric-


Posted by Adam S. on February 05, 2002 6:55 AM

Hiya,

Sure you can. Start by making your typical column chart with your two series. Then click on one of the series and go to format\data series\<axis tab>\and hit "secondary axis". This will automatically create a 2nd axis with the selected series.

Incidentally, if you start using the 2-axis (column-line) custom chart, you could also just right click on the line and go to "Chart type" and select columns.

Hope that helps out,
Adam S.

Posted by Eric on February 05, 2002 9:38 AM

I did try this, but it adds a secondary axis and takes the actual series column I want to plot off of the chart. Please advise.

-Eric-

Posted by Adam S. on February 07, 2002 2:46 PM

Hmm..

I suspect your series that follows the primary axis is "behind" the other series. Is the series visible as a line? Unfortunately, I don't know a way (an easy way at least) to force the bars to appear side by side on a dual axes chart (like it would appear in a typical column chart). I suppose you could stagger your data like so:

Instead of (ignore the periods- I hope this posts well)
x. .y. .y%
x1. .y1. .y1%
x2. .y2. .y2%
x3. .y3. .y3%

stagger your series like so

x. .y. .y%
x1. .y1
. .y1%
x2. .y2
. .y2%
x3. .y3
. .y3%

That may help
ADam S.