Moving Average Trendline

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

Hi all,

I have a chart that is devided in week number 1-52 and each week displays
one value in a stack. I want my moving average trendline to cover ONLY the
last 8 Weeks and nothing in the future..is this possible..?

Thanks again for this great forum...!
 
Hi Peter,

Not sure if im exactly understanding your question but i'll give it a try....

For eg. you're charting Weeks 1-10 and you want the moving average trendline
for last 8 weeks (week 3-10)

Go back to your excel data and add a new column "moving average" and do the
math for weeks 3-10 (w/ average(A:B) function). chart moving average as new
series on the same chart with original data week 1-10 and then select format
data series, axis tab, select secondary axis radio button this should get
what you want.

oh and make sure when you chart the moving average series includ weeks 1-2
and leave them empty, so the trendline will be in the proper location.

Example:

Week Moving Average
1 [empty]
2 [empty]
3 average
4 average
5 average
6 average
7 average
8 average
9 average
10 average

Hope this helps. click yes if it helped you!
 
Back
Top