Home |
Search |
Today's Posts |
#1
|
|||
|
|||
trendline in scatter plot
how can i add trendline or best fit line on a scatter plot which has multiple set of data. for example, i had 3 set of data for 3 different depth (0cm,15cm and 30cm) and i plot all three in a scatter plot. is it posible if i want only a line for describe all three depth despite of having a line for each color (3 line for 3 depth). or if i made all 3 depth together in one set of data and get a trendline from that scatter, how i can differentiate which point is 0cm, 15cm and 30cm?
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
trendline in scatter plot
Please give us a short example of your datasets
best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "shafierin" wrote in message ... how can i add trendline or best fit line on a scatter plot which has multiple set of data. for example, i had 3 set of data for 3 different depth (0cm,15cm and 30cm) and i plot all three in a scatter plot. is it posible if i want only a line for describe all three depth despite of having a line for each color (3 line for 3 depth). or if i made all 3 depth together in one set of data and get a trendline from that scatter, how i can differentiate which point is 0cm, 15cm and 30cm? -- shafierin |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
trendline in scatter plot
Not clear what you're asking.
A trendline added to a series uses every point in the series in its calculations. If you want a trendline to use more than one series in its calculations, you should create a series that uses all data from all series, and make a trendline from this combined series. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ On 4/5/2010 1:39 AM, shafierin wrote: how can i add trendline or best fit line on a scatter plot which has multiple set of data. for example, i had 3 set of data for 3 different depth (0cm,15cm and 30cm) and i plot all three in a scatter plot. is it posible if i want only a line for describe all three depth despite of having a line for each color (3 line for 3 depth). or if i made all 3 depth together in one set of data and get a trendline from that scatter, how i can differentiate which point is 0cm, 15cm and 30cm? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
trendline in scatter plot
You need to create a fourth set of data that combines all three of your
existing sets of data. Add the fourth set of data to your scatter plot as a new series. Select that series and add a trendline to it. Then format the series to have no lines and no symbols to it disappears. What you're left with is the original three series, each with a unique format, and the trendline that fits all of the data. HTH, Eric "shafierin" wrote: how can i add trendline or best fit line on a scatter plot which has multiple set of data. for example, i had 3 set of data for 3 different depth (0cm,15cm and 30cm) and i plot all three in a scatter plot. is it posible if i want only a line for describe all three depth despite of having a line for each color (3 line for 3 depth). or if i made all 3 depth together in one set of data and get a trendline from that scatter, how i can differentiate which point is 0cm, 15cm and 30cm? -- shafierin . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mixing scatter plot with a category plot | Charts and Charting in Excel | |||
Sine trendline in scatter? | Charts and Charting in Excel | |||
different color on scatter plot separated by a trendline | Charts and Charting in Excel | |||
Scatter Plot with Trendline and equation | Excel Discussion (Misc queries) | |||
Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel |