ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I get a trendline for all data series, instead of just one. (https://www.excelbanter.com/charts-charting-excel/163-how-do-i-get-trendline-all-data-series-instead-just-one.html)

Dave Darling

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.

Michael R Middleton

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




All times are GMT +1. The time now is 12:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com