View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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