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

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
 
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/
_______
 

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

How do I put words as the Y axis values? 0
How do I adjust marker spacing in Excel scatter plot? 1
Combined line-scatter graph with 2 Y-axis messed up 2
X Y (Scatter) Chart EXCEL 2007 1
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1
Scale on X & Y Axis of the scatter chart 3
How do I specify X,Y axis and Series values in a line graph? 5
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4

Top