Binding Pivottable to Chart

[Hans Riis]

Hi.

I'd like to bind a Pivottable to a Chart. I can do the opposite but if I
create a Chart with an OLAP cube as the data source I can't make the
Pivottable get its data from it.

The reason I don't do it "the usual way" is that you seemingly can't modify
the axes of a chart if it's bound to a pivottable.

Ideally I'd prefer to just synchronize two filters in the chart and
pivottable so I could show more measures in the table than in the chart.
However, I've searched the forum without finding a solution to this.

Thanks, Hans Riis

 

[Guest]

then uh

have the pivotTable connect to the data and bind the chart the the
pivotTable

why won't that work for you?