How do I set up a second y-axis on a scatter chart?

S

Suzannemoss

x-axis = Price from $1.30 to $1.80
left y-axis = % of ownership from 24% to 30%
right y-axis = $value of deal from $x to $y

How should information be displayed to set up scatter diagram with 2 y axes?

I should be grateful if you would email me at [email protected].

Thank you
Suzanne
 
J

Jon Peltier

Suzanne -

Plot your two series (you need at least two series before Excel will allow you
secondary axes). Double click on one of them, and on the Series tab, check
Secondary. This gives you by default just a secondary Y axis. To get a secondary X
axis in addition to or instead of the secondary Y axis, select Chart Options from
the Chart menu, and on the Axes tab, check the combination of axes that you want.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Top