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
|
|||
|
|||
Chart with 39-week moving average
Hello,
I have a spreadsheet that pulls data on the click of a button from the internet the daily fund prices. I want to be able to produce charts with 39-week moving averages. My excel is 97 and I've just found out that the greatest number allowed for moving average is 35. Any way I can produce the moving average by Excel directly without me creating a separate sheet to calculate the 39-week moving averages myself?? Thanks. Herbert |
#2
|
|||
|
|||
I don't believe 35 is the limit on the # periods in a moving average
trendline. The limit is the number of data points in the series. So, if you have 39 or more points in the series, XL will let you create a 39 week moving average trendline. That said, one can always compute a moving average through worksheet cells. Assuming your data are in A1:A{n}, in B39 enter =AVERAGE (A1:A39). Copy B39 down column B as needed. Alternatively, adapt the idea behind the 'Graph only the last so many entries in a data series' example at http://www.tushar- mehta.com/excel/newsgroups/dynamic_charts/index.html#LastSoMany -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Hello, I have a spreadsheet that pulls data on the click of a button from the internet the daily fund prices. I want to be able to produce charts with 39-week moving averages. My excel is 97 and I've just found out that the greatest number allowed for moving average is 35. Any way I can produce the moving average by Excel directly without me creating a separate sheet to calculate the 39-week moving averages myself?? Thanks. Herbert |
#3
|
|||
|
|||
Thanks!
I'm very stupid, just found out I've just at the moment 36 data points! Thanks Tushar, you have there in your website a lot of useful and very practical tips. Herbert "Tushar Mehta" ¦b¶l¥ó ¤¤¼¶¼g... I don't believe 35 is the limit on the # periods in a moving average trendline. The limit is the number of data points in the series. So, if you have 39 or more points in the series, XL will let you create a 39 week moving average trendline. That said, one can always compute a moving average through worksheet cells. Assuming your data are in A1:A{n}, in B39 enter =AVERAGE (A1:A39). Copy B39 down column B as needed. Alternatively, adapt the idea behind the 'Graph only the last so many entries in a data series' example at http://www.tushar- mehta.com/excel/newsgroups/dynamic_charts/index.html#LastSoMany -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Hello, I have a spreadsheet that pulls data on the click of a button from the internet the daily fund prices. I want to be able to produce charts with 39-week moving averages. My excel is 97 and I've just found out that the greatest number allowed for moving average is 35. Any way I can produce the moving average by Excel directly without me creating a separate sheet to calculate the 39-week moving averages myself?? Thanks. Herbert |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Selecting Charts in a Macro | Herman Merman | Charts and Charting | 1 | August 18th, 2004 12:25 AM |
Comparing y-t-d average between 2 years for each year without surpassing present year's week | Yvon | General Discussion | 3 | July 13th, 2004 04:07 PM |
Moving buttons on a chart | Mark | Charts and Charting | 1 | May 26th, 2004 04:24 PM |
Chart menu visible property | Sandy V | Charts and Charting | 8 | May 17th, 2004 01:39 PM |
Styles for chart | Debra Dalgleish | Charts and Charting | 1 | October 3rd, 2003 12:27 PM |