chart only displays one measure from pivotable

[Aymer]

Scenario: I have a pivottable and pivotchart in the same
web page. both are office web component version 10. the
pivottable is populated through an xml that was retrieve
in the database.

pivottable.xmldata = oRs("xmlstring") //from database

the pivotable is populated with multiple dimensions and
multiple measures.

the pivotchart datasource is pointed at the pivotable.

pivotchart.datasource = pivottable

the pivotchart displays a graph equivalence of the
pivotable.

Problem: the pivotchart plots or display onlys one
measure. after adding a measure into the pivotchart
through the chart fieldlist, the chart automatically
plotted the rest of the measures.

Question: When I set the pivotchart's datasource equal to
the pivotable, how, through asp code, do i make the
pivochart to display all the measure during load time?

thanx in advance for your help,
aymer
aymerb[@].yahoo.com

 

[Thao Moua [ms]]

Before you add the fields to the chart, add these lines
of code.

set c=webchart.constants
webchart.PlotAllAggregates = c.chPlotAggregatesSeries

Thao Moua
OWC Webchart Support

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.htm