Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
2 sets of "y" data points with one set of "x" data points
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? -- Doug |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
2 sets of "y" data points with one set of "x" data points
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. -- David Biddulph "doug" wrote in message ... 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? -- Doug |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
2 sets of "y" data points with one set of "x" data points
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "doug" wrote in message ... 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? -- Doug |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
"propagating" a chart across a number of data sets | Charts and Charting in Excel |