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+ Cross post details 00http://www.excelguru.ca/forums/showthread.php?1724-Moving-average-yearly-6-month-3-month-1-monthand-gives-comparison-using-line-graph
Thanks in Advance..
Kind Regards
Jose
Bookmarks