Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "neally" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
show 3 sets of data per data point in a scatter plot | Charts and Charting in Excel | |||
How do I change data labels on scatterplot | Charts and Charting in Excel | |||
how do i link up 2 sets of data into 1 set of data in excel | Excel Worksheet Functions | |||
help comparing two sets od data to find the odd data | Excel Worksheet Functions | |||
scatterplot of data with gaps | Charts and Charting in Excel |