Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
How do i create one scatterplot with three separate data sets and a best-fit
line to go with each set? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Make an XY chart with the first set of X-Y values. Copy the second set of
X-Y values, select the chart and use Edit menu Paste Special, and add the data as a new series, categories in first column (row). Repeat for the third set of X-Y values. Add the trendline to each series by selecting the series, right clicking, and choosing Add Trendline. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "neally" wrote in message ... How do i create one scatterplot with three separate data sets and a best-fit line to go with each set? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I change data labels on scatterplot | Charts and Charting in Excel | |||
Scatterplot chart legend | Charts and Charting in Excel | |||
Scatterplot Question | Charts and Charting in Excel | |||
scatterplot of data with gaps | Charts and Charting in Excel | |||
scatterplot chart with reverse axis | Charts and Charting in Excel |