Thread: PivotChart

I'm using a pivottable and chart to display data.

The data in the table is displayed like this:

(apologies about the formatting, but basically, column A is "date" and columns B through D hold total numbers for three different types of event per day - so col B for Event 1, col C for Event 2 and col D for Event 3)

Date Actions
30/08/2007 4 4
31/08/2007 2 2
01/09/2007 1 1
03/09/2007 1 1
04/09/2007 2 2
05/09/2007 3 1 4
06/09/2007 2 2
07/09/2007 4 4
10/09/2007 3 3
11/09/2007 3 3
12/09/2007 4 4
14/09/2007 1 1
17/09/2007 2 1 3
18/09/2007 2 2 4
19/09/2007 1 1
20/09/2007 2 2
21/09/2007 2 2
22/09/2007 2 2
23/09/2007 1 1
24/09/2007 2 2
25/09/2007 3 3
26/09/2007 3 3
27/09/2007 3 3
28/09/2007 8 8
29/09/2007 2 2
30/09/2007 1 1
01/10/2007 1 1
02/10/2007 6 6
03/10/2007 1 1
05/10/2007 2 2
06/10/2007 1 1
09/10/2007 1 1
10/10/2007 5 5
11/10/2007 3 3
12/10/2007 5 5
13/10/2007 1 1
14/10/2007 1 1
16/10/2007 4 4
17/10/2007 1 1
18/10/2007 1 1
19/10/2007 2 2
20/10/2007 1 1
22/10/2007 2 2
Grand Total 220 9 21 250

I'm displaying this data in a pivotchart, but as time passes, and the data increases, the chart has become so crowded it's unreadable.

What I need to do is select the last 30 days worth of data and just display that.

The last 30 records in the table isn't as useful, as you can see - on some days there are aren't any events at all, so no record, which means going back 30 records will take the chart back further than 30 days.

Is there a simple way of telling excel to only just data if it falls between "TODAY-30 and TODAY"?

Any help you offer would be greatly appreciated!