LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
KT
 
Posts: n/a
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
30 Day Moving Average Ignoring Blank Cells ethatch Excel Worksheet Functions 2 January 17th 06 09:37 AM
how do I extract the moving average trendline point data? bobb Charts and Charting in Excel 2 January 10th 06 09:04 AM
moving average of figures from separate tables Melissa Excel Discussion (Misc queries) 15 January 6th 06 08:16 AM
Moving average Mike B Excel Worksheet Functions 8 March 21st 05 04:41 PM
Plotting moving average line on a chart Herbert Chan Charts and Charting in Excel 1 February 26th 05 08:31 PM


All times are GMT +1. The time now is 03:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"