ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Trendling for each month when data is for 5 months (https://www.excelbanter.com/charts-charting-excel/198452-trendling-each-month-when-data-5-months.html)

Rosemary

Trendling for each month when data is for 5 months
 
I have data from 1/1/08 thru 8/10/08 - how do i set a trending line for each
month of data to be shown only for the monthly period

Jon Peltier

Trendling for each month when data is for 5 months
 
Plot each month's worth of data as its own series, then apply a trendline to
each series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Rosemary" wrote in message
...
I have data from 1/1/08 thru 8/10/08 - how do i set a trending line for
each
month of data to be shown only for the monthly period





All times are GMT +1. The time now is 11:08 AM.

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