Prev: Chart doesn't recognize date format
Next: excel chart
From: shafierin on 5 Apr 2010 01:39

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
From: Bernard Liengme on 5 Apr 2010 09:10
Please give us a short example of your datasets
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"shafierin" <shAfIeriN(a)yahoo.com> wrote in message
news:shafierin.5ff3d7a(a)excelbanter.com...
>
> 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

From: Jon Peltier on 5 Apr 2010 10:42
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?
>
>
>
>
From: EricG on 5 Apr 2010 13:15
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
> .
>
 | 
Pages: 1
Prev: Chart doesn't recognize date format
Next: excel chart