Is it possible to generate a pivot table (includes Column A "Create Date-ex. 11/1/2013 and Column B "Total-ex. the total for 11/1/2013 was 89) and instead of making a chart, make a calendar with day, date, daily total and then a weekly total?
I have attached an example pivot with a manually created calendar to show what I am trying to generate automatically.
Bookmarks