Filter a Pivot Chart

[dmkennard2]

Hi,
I have got the code to create a pivot and a chart from the source data.
The problem i have is there is far too much data to be displayed in a chart.

Is there a was of deselecting all the entries, in this case date, and only display the first date that is in cell A5 in the pivot table?

At the moment the list is just every individual entry in the pivot table ie:

    ActiveChart.PlotArea.Select
    ActiveChart.ChartType = xlLineMarkers
    With ActiveChart.PivotLayout.PivotTable.PivotFields("Date")
        .PivotItems("02/07/2007").Visible = False
        .PivotItems("03/07/2007").Visible = False
        .PivotItems("04/07/2007").Visible = False
        .PivotItems("05/07/2007").Visible = False
        .PivotItems("06/07/2007").Visible = False
        .PivotItems("07/07/2007").Visible = False
         etc...

Dazz

 

[GlennUK]

Why don't you have a page field of Date?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[dmkennard2]

Hi, Thanks for the reply.

I would like the option to be able to display more than one day when looking at the chart.

Choosing one day at chart creation make the chart a lot less busy and easier for users to understand.