I have a pivot table that counts the actions done by date.
EX:
HTML Code: 
On the worksheet there are 6 lines:
5/10/10 Paul Call
5/11/10 Paul Visit
5/1/10 Paul Visit
etc...


On the chart: Values = Date Count

This is continued throughout the month
I want to seperate the counts by weeks (have 4 charts that looks at the same input and displays the count for that week.

The problem: there are 20 people and potentially 800+ actions

What I have done:
Created the Pivot tables so they look right
On the Date, I Filtered each chart Between X date and x date

All the charts show the same result - coworker says it is because the counts are displayed not the dates.



Any Help appreciated.