Thread: How do I fit a line on an excel plot to a portion of the data?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default How do I fit a line on an excel plot to a portion of the data?
Hi,

Trend lines are based on all the data points in a series.
To get a trend line on a subset of data you will need to add a new series
based on only that subset.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"mechengstudent" wrote in message
...
I want a best fit line to go pass through the obviously linear portion of
the
data and ignore all other points, how do i do this?

Reply With QuoteReply With Quote