View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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