View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Del Cotter Del Cotter is offline
external usenet poster
 
Posts: 560
Default how to draw trend lines through only certain data points

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.