• Status: Solved
• Priority: Medium
• Security: Public
• Views: 461

# Moving average in excel 2010

I need to do a 12 month moving average but when i do a trend line i get an option of 2 or 3 and not 12. how can a do a moving average for 12 months?
0
jlcannon
• 2
1 Solution

Commented:
jlcannon,

Trendline is not moving average. You can use moving average to create a Trendline, which the 2 or 3 you are mentioning is basically how many point to use as average scope when creating the Trendline.

Depends on your definition of moving average, you have to do it on the spreadsheet instead of the chart, then plot the moving average as one of the series.
Moving-Average-Sample.xlsx
0

Commented:
Here is another example of moving average with last 12 points.
Moving-Average-Sample.xlsx
0

Author Commented:
thank you, exactly what i needed
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.