How to add another y-axis range into chart?

E

Eric

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
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Horizontal axis to the bottom 1
How to insert 2 scales on y-axis? 3
Using a 'Name' to Update Chart Titles & "Y" Axis Scale 2
Dynamically Scale X Axis on Column Chart Based on Number of Catego 1
Chart - Secondary Y-axis with different values/scale 2
Formatting 'X' Axis -- 2 fundamental differences 7
scales of 1st and 2nd series 1
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1

Top