I've created a chart indicating the win/loss record of a major league
baseball team plotted over time. The Y-axis ranges from 0 to 1. I'd like
another Y-axis on the right side of the chart which would basically be the
same thing except multiplied by 162 (number of games in the season) so you
could look at the chart and say, "Hmm, if they continue at this rate, they'll
have 98 wins by the end of the season" (for example). Creating a secondary
axis didn't seem to help unless I missed something.
Thanks in advance!

You need a second series in order to plot a secondary axis. This is easy,
since you don't need to show it in this case. just put some dummy values in
a few cells, add them to the chart as a new series, and format this new
series to appear on the secondary axis. While formatting, also give this
series no visible features (no line, no markers, no fill, whatever). Format
the scale of the secondary so it ranges from 0 to 162.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"mikeweasel" wrote in message
...
I've created a chart indicating the win/loss record of a major league
baseball team plotted over time. The Y-axis ranges from 0 to 1. I'd like
another Y-axis on the right side of the chart which would basically be the
same thing except multiplied by 162 (number of games in the season) so you
could look at the chart and say, "Hmm, if they continue at this rate,
they'll
have 98 wins by the end of the season" (for example). Creating a secondary
axis didn't seem to help unless I missed something.
Thanks in advance!

On Thu, 11 Jun 2009 09:02:01 -0700, mikeweasel
wrote:

I've created a chart indicating the win/loss record of a major league
baseball team plotted over time. The Y-axis ranges from 0 to 1. I'd like
another Y-axis on the right side of the chart which would basically be the
same thing except multiplied by 162 (number of games in the season) so you
could look at the chart and say, "Hmm, if they continue at this rate, they'll
have 98 wins by the end of the season" (for example). Creating a secondary
axis didn't seem to help unless I missed something.
Thanks in advance!

Create a second chart and place it there. A separate chart, not within
the existing chart.

A second chart is so much harder to maintain than a secondary axis in the
same chart.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Archimedes' Lever" wrote in message
...
On Thu, 11 Jun 2009 09:02:01 -0700, mikeweasel
wrote:

I've created a chart indicating the win/loss record of a major league
baseball team plotted over time. The Y-axis ranges from 0 to 1. I'd like
another Y-axis on the right side of the chart which would basically be the
same thing except multiplied by 162 (number of games in the season) so you
could look at the chart and say, "Hmm, if they continue at this rate,
they'll
have 98 wins by the end of the season" (for example). Creating a secondary
axis didn't seem to help unless I missed something.
Thanks in advance!

Create a second chart and place it there. A separate chart, not within
the existing chart.