Baseball chart

M

mikeweasel

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!
 
J

Jon Peltier

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-06-ACNJ/AdvExcelConf200906ACNJ.html
_______
 
A

Archimedes' Lever

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!
Click to expand...

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

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

Chart distorts secondary axis when the x-axis is logarithmic 5
X-Axis Units Disappear in Stacked Area Chart (Excel 2007) 0
Using the full width of an Excel chart with two Y-axes 2
Chart data scrunches to left when adding X axis date series 0
vertical scale on both ends of bar chart 1
Help with Bar-Line Chart..not aligned?? 1
Employee Schedule not plotting properly - chart type / data series not correct 0
secondary category axis reset to min=0 max=0 on save 1

Top