If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Moving Average Trendline
The graph I am creating has a lot of noise in it. I want to smooth it out.
Right now I am using a moving average trendline that kind of does the trick. When I do this I want to be able to work with the points that it has created to make the trendline. Is there a way to get the points that this line makes up? Or is there a way to filter the points in the graph such as take every tenth data point or would I have to do that with the original set used to make the graph by using a macro or something like that? |
#2
|
|||
|
|||
Moving Average Trendline
You can calculate your own moving average. Say your data is in column D,
starting in cell D2. To do a 10-point moving average, start in cell E11, and enter this formula: =average(D211) fill this down to the end of the data in column D. Plot this data in your chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "KT" wrote in message ... The graph I am creating has a lot of noise in it. I want to smooth it out. Right now I am using a moving average trendline that kind of does the trick. When I do this I want to be able to work with the points that it has created to make the trendline. Is there a way to get the points that this line makes up? Or is there a way to filter the points in the graph such as take every tenth data point or would I have to do that with the original set used to make the graph by using a macro or something like that? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
30 Day Moving Average Ignoring Blank Cells | ethatch | Worksheet Functions | 2 | January 17th, 2006 09:37 AM |
how do I extract the moving average trendline point data? | bobb | Charts and Charting | 2 | January 10th, 2006 09:04 AM |
Chart with 39-week moving average | Herbert Chan | Charts and Charting | 2 | September 7th, 2004 02:29 PM |
Moving average trendlines | Rob | Charts and Charting | 2 | October 21st, 2003 02:58 PM |
Wighted Moving average | Peter | Worksheet Functions | 1 | October 17th, 2003 01:19 PM |