Hello group,

I'd like some help drawing a trendline in Excel. We have price datasets
going back five years that we want to chart using a line, with an
accompanying trendline. The trendline should be a moving average that uses
the same month for each year to determine the average. For example. If
January 2007's price is "5" and the previous four years' January values were
4, 4, 5, 5 (for an average of 4.5), then 4.5 should be the trendline value
for January 2007.

I'm only finding options in the chart wizard and tools for the standard
moving average of a given range (such as x months).

Please help!

DC G