| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| start at a specific point | Charts and Charting in Excel | |||
| formula to identify exact point where trendline intersects data | Excel Worksheet Functions | |||
| How do I plot a trendline that goes through a specified point? | Charts and Charting in Excel | |||
| how do I extract the moving average trendline point data? | Charts and Charting in Excel | |||
| How do i approximate the value of a point on the trendline? | Charts and Charting in Excel | |||
Hybrid Mode
