View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default how to draw trend lines through only certain data points

Split the data into two series, and add a trendline to each.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"akh2103" wrote in message
ps.com...
hello all--
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.
-abe