Moving average yearly, 6 month, 3 month, 1 monthand gives comparison using line graph

jose_valooran

New member
Joined
May 23, 2013
Messages
3
Reaction score
0
Points
0
Dear friend,


I am tracking my delivery out figures. Now I want to track 1 year, 6 month, 1 month- monthly average whose results I want in a comparative line graph which gives result against today.(something similar to Moving avg. graph used by share traders for technical analysis..)


I have another problem in this. Some of my items is not in existence for 1 year. For such items formula should be( (total delivery/No of days from 1st delivery to today)*30 ).. similarly for all avg calculations......


Please find ATTACHED sample data


Thanks in Advance..


Kind Regards
Jose
 

Attachments

  • Moving aVERAGE.xlsx
    9 KB · Views: 53
Cross posting is not forbidden nor a crime. The only thing we ask is that you add a link to your other post(s) to avoid useless work
 
Moving average yearly, 6 month, 3 month, 1 monthand gives comparison using line graph

Dear friend,


I am tracking my delivery out figures. Now I want to track 1 year, 9month, 6 month, 1 month- monthly average whose results I want in a comparative line graph which gives result against today.(something similar to Daily Moving avg. graph used by share traders for technical analysis..)


I have another problem in this. Some of my items is not in existence for 1 year. For such items formula should be( (total delivery/No of days from 1st delivery to today)*30 ).. similarly for all avg calculations......

I want a way to see this chart on a daily basis

Please find ATTACHED sample data




Thanks in Advance..


Kind Regards
Jose​
 

Attachments

  • Moving aVERAGE.xlsx
    8.7 KB · Views: 28
Back
Top