Forum Discussion
Limiting the data used to calculate a trendline
Hello, Many of us calculate trendlines on Excel graphs. Sometimes the data includes many outliers that should not be included in the calculations. Is there any quick way to limit the data inclu...
short answer is no.
what i do is create a copy of that data set I want the trendline for as a new series and then perform trendline on that series. In this way you can even show via color or data point shapes or line types which data is included in the trendline and which is not
what i do is create a copy of that data set I want the trendline for as a new series and then perform trendline on that series. In this way you can even show via color or data point shapes or line types which data is included in the trendline and which is not