On Wed, 13 Jun 2007, in microsoft.public.excel.charting,
akh2103 said:
i need to make a scatterplot with trendlines that only go through some
of my data. then i need a second trend line for the second part of my
data. any ideas on how can i do this? thanks.
Make three columns in your spreadsheet. Have the first column be all
your data, the second column be only the data you're interested in for
your first trendline, and the third column be only the data for the
second trendline. Then plot all three series, make trendlines for the
second two, then format them so they're invisible. Then you'll have one
set of points and two trendlines that apparently go through those
points.
--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.