Secondary Axis chart
 

I need to create a chart with two axis. I want both the data series to be
displayed as columns on the same graph. So far I have only been able to a
secondary axis chart with a column and line - by going to custom charts in
'type of chart'. Anyone know how I can make both the data series appear as
columns? I have also tried going to the Format menu, clicking on Selected
Data Series and then clicking Secondary axis on the Axis tab. This makes one
series go in front of the other though and I can't get them to go side by
side so you can see both series. (Hope that made sense!)

Hi,

You need to alter the layout of your data slightly.
For explanations of how to do this
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

McInnes wrote:
I need to create a chart with two axis. I want both the data series to be
displayed as columns on the same graph. So far I have only been able to a
secondary axis chart with a column and line - by going to custom charts in
'type of chart'. Anyone know how I can make both the data series appear as
columns? I have also tried going to the Format menu, clicking on Selected
Data Series and then clicking Secondary axis on the Axis tab. This makes one
series go in front of the other though and I can't get them to go side by
side so you can see both series. (Hope that made sense!)

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info