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!)