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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 (e-mail address removed).

Thank you
Suzanne
 
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/
_______
 
Back
Top