Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Moving Average Trendline
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...! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Moving Average Trendline
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! "Peter" wrote: 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...! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
average/trendline in chart | Charts and Charting in Excel | |||
Stop moving trendline equations | Charts and Charting in Excel | |||
Moving Average Trendline | Charts and Charting in Excel | |||
how do I extract the moving average trendline point data? | Charts and Charting in Excel | |||
Moving average | Excel Worksheet Functions |