Keeping data separate when adding a second axis
 

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

Keeping data separate when adding a second axis
 

Hi,

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

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

Cheers
Andy

Eric wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

Keeping data separate when adding a second axis
 

That's exactly it, thanks for the help.

"Andy Pope" wrote:

Hi,

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

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

Cheers
Andy

Eric wrote:
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, Microsoft MVP - Excel
http://www.andypope.info