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

Hi,

I think this may help.
http://peltiertech.com/Excel/Charts...sOnTwoAxes.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

That's exactly it, thanks for the help.

"Andy Pope" wrote:

> Hi,
>
> I think this may help.
> http://peltiertech.com/Excel/Charts...sOnTwoAxes.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
>