HELP Bind Pivottable to Chart !!!
I can't figure out the statement to assign the chartspace1 .datasource in Code.
I am trying to bind a MS Chart with a Pivottable but it does not
I've tried
a) ChartSpace1.DataSource = PivotTable1 SEND an Error at debug
The MS documentation say I should use the first option but doesn't work...
b) ChartSpace1.DataSource = PivotTable1.Datasource
ChartSpace1.PlotAllAggregates = c.chPlotAggregatesCategories
The second line SENDS an Error at debug
Can anyone Help Me???