Programming PivotChart

[Guest]

I would like to programmatically change the current filter, then change the
title of the chart to correspond to the the new filter. I can handle the
title part, buy I can't figure out how to get to which values in the filter
on the pivotchart are selected.

The idea is to trigger off a keystroke to set the filter of the pivotchart
to a specific value, so I can quickly switch views.

Any help would be great.

Thanks
Nathan

 

[Guest]

It seems to be somewhere close to this:

Me.ChartSpace.Charts(0).SeriesCollection.PivotAxis.Data.FilterAxis.FieldSets.Item(0).Fields.Item(0).IncludedMembers(0)

But I can't figure out how to modify it.

Any help would be great.

 

[Guest]

Ok, here ya go for anyone out there that is curious. Although there is
probably a better way...


Me.ChartSpace.Charts(0).SeriesCollection.PivotAxis.Data.FilterAxis.FieldSets.Item(0).Fields.Item(0).IncludedMembers = Array("20", "22")

I know that 20 and 22 are valid, which I suppose could be verified using the
Allmembers collection. But this works for what I'm looking for.

Nathan