I have a string of data the represents each week of the year. B4 through B10 indicate all the data i record for week 1, C4 through C10 indicates the data in week 2, etc going all the way to AB4 through AB10.
I want to be able to automatically generate a report and graphs that will look at an 8 week trend, an average of the 8 weeks.
How can I do this with excel? I am sorry I am not incredibily skilled with the formulas.
I want to be able to automatically generate a report and graphs that will look at an 8 week trend, an average of the 8 weeks.
How can I do this with excel? I am sorry I am not incredibily skilled with the formulas.