View Single Post
  #2  
Old December 22nd, 2009, 03:18 PM posted to microsoft.public.excel.charting
Andy Pope
external usenet poster
 
Posts: 2,088
Default How to add another y-axis range into chart?

Hi,

In order to have 2 y-axis you require a minimum of 2 data series.
Select the second data series and via the Format dialog set the series to
the Secondary axis.

This explains how to enable the secondary y axis when only 1 series is
required.
http://www.andypope.info/tips/tip005.htm

You can not use the 3d styles if you want dual axis.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Eric" wrote in message
...
Does anyone have any suggestions on how to add one scale on right y-axis
and
one scale on left y-axis?
Thanks in advance for any suggestions
Eric