scatterplot with three data sets

G

Guest

I need specific instructions on how to enter three data sets into one
scatterplot in Excel 2003. I got instructions before but they are not
detailed enough, I am not very proficient in Excel. Would someone be so kind
as to let me know how to set up the cells in the spread sheet and get them to
the X-Y chart? When I try to put the second set of Y-values in the chart it
changes the first set to the second.
 
J

Jon Peltier

Set up six columns, for Series A X, Series A Y, Series B X, Series B Y,
Series C X, Series C Y. Select Series A X and Y and create the XY chart.
Copy Series B X and Y, select the chart, use Edit menu > Paste Special to
add the data as a new series, with categories (X values) in the first
column. Repeat this last for series C.

- Jon
 

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

Top