Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get a trendline for all data series, instead of just one.
I need to retrieve R squared values, and trendline information for all data
series within a block of data. Excel is only letting me get trendline information on one data series, which is almost useless for me. |
#2
|
|||
|
|||
Dave Darling -
I need to retrieve R squared values, and trendline information for all data series within a block of data. Excel is only letting me get trendline information on one data series, which is almost useless for me.< You can add a trendline and get R squared for each data series. If you need a trendline for the combination of several data series, you could copy data into a column containing all combined data, plot that combined data series as a separate series, and add a trendline. - Mike www.mikemiddleton.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
Plotting different length series in a chart | Charts and Charting in Excel | |||
How do I get the trendline equation from Excel to script? | Charts and Charting in Excel | |||
Format Data Series Markers | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |