Bind ChartSpace to PivotTable

[Francis]

Hi all,

How can I bind a ChartSpace to a PivotTable in OWC 9.0? I can do this easily
in OWC 10.0. But I can not repeat this in OWC 9.0.
Can anyone help me?

Best regards,
Francis

 

[Thao Moua [ms]]

I assume you have the PivotList control all setup and populated. Use the following code to bind the Chartspace control to the PivotList control

set wc.datasource = pivotcontro

wc.datasourcetype = C.chDataSourceTypePivotLis
set chart = wc.charts.ad
chart.type = C.chChartTypeBarStacked100
chart.haslegend = tru

chart.setdata C.chDimSeriesNames, 0, C.chPivotRows 'C.chPivotColAggregate
chart.setdata C.chDimCategories, 0, C.chPivotColumns 'C.chPivotRowAggregate
chart.setdata C.chDimValues, 0,

Thao Mou
OWC Chartspace Suppor

This posting is provided "AS IS" with no warranties, and
confers no rights. Use of included script samples are
subject to the terms specified at
http://www.microsoft.com/info/cpyright.ht

----- Francis wrote: ----

Hi all

How can I bind a ChartSpace to a PivotTable in OWC 9.0? I can do this easil
in OWC 10.0. But I can not repeat this in OWC 9.0
Can anyone help me

Best regards
Franci

 

[msegura]

And does anybody know how can I do the inverse operation, ie, bind
PivotTable to a ChartSpace??
Thanks :eek

 

[Alvin Bruney - ASP.NET MVP]

What you should do is bind the pivot table to the data that the chart is
built from.
--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006