Trendline partial data start point

[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

 

[Shane Devenshire]

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.