If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Trendline partial data start point
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 |
#2
|
|||
|
|||
Trendline partial data start point
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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "JJ@Mich" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|