Trendline partial data start point

  • Thread starter Thread starter JJ@Mich
  • Start date Start date
J

JJ@Mich

I was able to create a linear trendline for only portion of the data in my
pareto (by adding new series), but the line always starts at the beginning of
the chart - ie, the first bar in the pareto - no matter where I define the
start of the data for it. Is there a way to have it start at the stack that
the first datapoint actually represents?
Thanks
 
Hi,

You can calculate the trendline in the spreadsheet and then plot whatever
portion of that you want. Depending on the type of trendline you can use
LINEST, LOGEST, SLOPE and INTERCEPT. Or you can get the formula from the
charts trendline and set up the equation in the spreadsheet.
 
Back
Top