2 sets of "y" data points with one set of "x" data points

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

Guest

I am using Excel 2003 and trying to do a model for math class comparing the
average ocean temperature to storm activity for the last 20 years. My x axis
will be the year, then I would like to overlay the two sets of data (temp &
storms). Any ideas on how to accomplish this?
 
Put your years in column A from A2 downwards, leaving cell A1 blank. Put a
title for your first series such as "Average ocean temperature" in B1, with
the temperatures in B2 downwards, and similarly "Storm activity" in C1 with
numbers from C2 downwards.
Select the range from A1 to the bottom of the data in column C.
Insert/ Chart/ XY/ choose a subtype from the pictures on the right/ progress
on through the wizard.
When you've got your chart, if the values in columns B and C cover
drastically different ranges, you can select your column C series on the
chart, Format Series/ Axes/ and select a secondary Y axis.
 
Put X values into column A starting in row 2, Y1 values (temp) in column B
starting in row 2, and Y2 values (storms) in column C starting in row 2.
Leave A1 blank, but put labels in B1 and C1.

Select this range, or a single cell in the range, and start the chart
wizard, choose your chart type, and continue through the wizard. If you have
problems, post back.

- Jon
 
Back
Top