Attached is a sample workbook using the superstore data set. Basically, my problem is I want to look at a 7 day rolling average, with lines colored by year. The way i have it set up now works except for in January. January 1st 2016 and 2015 is not showing the rolling data, it is just giving me the exact number of records for that day. Is there a way to keep the lines separated by year, but have the calculation account for the data in the last week of the year before?