Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How do I set up a second y-axis on a scatter chart?
0 views
Skip to first unread message
Suzannemoss
Oct 12, 2004, 9:29:04 PM10/12/04
to
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
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 suz...@beerworth.com.
Thank you
Suzanne
Jon Peltier
Oct 12, 2004, 11:04:48 PM10/12/04
to
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/
_______
0 new messages