Keeping data separate when adding a second axis

[Eric]

I have two data series that fall under the same categories that I want to
graph on a clustered column chart. I want to add a second axis because the
values of each series are far apart, but when I add a second axis, the values
overlap each other on the chart. Can I have a second axis without the series
overlapping in this type of chart.

Thanks,
Eric

 

[Andy Pope]

Hi,

I think this may help.
http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

If not post back with a clear explanation of your problem. Including
chart type, excel version.

Cheers
Andy

 

[Eric]

That's exactly it, thanks for the help.

Hi,

I think this may help.
http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

If not post back with a clear explanation of your problem. Including
chart type, excel version.

Cheers
Andy