Produce an appropriate data series in your worksheet, and use the TREND
function.
--
David Biddulph

"DC Gringo" wrote in message
...
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