Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do i calculate a 50 moving averager?
When generating a trendline, the original data still remains. Is there a way
to get rid of the data (other than changing the color to white) and simply having the trendline? I was thinking if it is not an option i can calculate the moving averager and merely graph that column. Let me know what is the best way to go about this....Thank you |
#2
|
|||
|
|||
I don't think you can maintain the trendline if you remove the underlying
data. You can simply create a new column to graph which is the moving average by using the average command and then dragging it down. By this I mean lets say you had a column of 100 obeservations in column a1 to a100. You wanted to create the 5 period moving average. So in cell b5 you would enter =average(a1:a5) then copy this into cells b6 through b100. Is this what you want to do? Maybe I'm saying things you allready know. "Jason" wrote: When generating a trendline, the original data still remains. Is there a way to get rid of the data (other than changing the color to white) and simply having the trendline? I was thinking if it is not an option i can calculate the moving averager and merely graph that column. Let me know what is the best way to go about this....Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I calculate Vacation Time earned based on length of emplo. | Excel Discussion (Misc queries) | |||
formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
Plotting moving average line on a chart | Charts and Charting in Excel | |||
Not able to calculate. | Excel Worksheet Functions | |||
How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions |