How do i calculate a 50 moving averager?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top