How do you set filters programatically on OWC10 Charts?

[Jim Hubbard]

I need to set filters programatically on an owc10 chart but I can find no
examples of this anywhere.

Any help you could give would be greatly appreciated.

 

[Jim Hubbard]

I am using an ado recordset for the data source....if that helps.

I know I could filter the data in the recordset, but the request was to
allow all fields to show in the chart control, but only have certain fields
showing when it first displays. The other fields should be in the chart for
a user to select if they want.

 

[Dan Ricker]

One way is to use the InternalPivotTable property.

This give you access to the complete OWC10/11 PivotTable
and the FieldSets/Fields filtering properties can be set
there.

The OWC VBA help file has examples for setting filtering
on the Pivot.

 

[Jim Hubbard]

Is the internal pivot table created automagically from my ado recordset data
source?

 

[Dan Ricker]

Yes it is. The InternalPivotTable is created anytime
that "literal data" is not used (e.g. Arrays of values).

So any Relational Or OLAP data source generates the
InternalPivotTable

 

[Jim.Hubbard]

grrrrrrrr!!!



setting the IncludeMembers/ExcludeMembers takes care of the categories,
but I'd like to set the same thing for the series data......