How to add another y-axis range into chart?
 

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

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