PlotAllAggregates Property

Microsoft Office Web Components Object Model

Show All

PlotAllAggregates Property

       

Returns or sets a ChartPlotAggregatesEnum constant that determines which fields are plotted when the chart control is bound to a relational data source. Read/write.

ChartPlotAggregatesEnum can be one of these ChartPlotAggregatesEnum constants.
chPlotAggregatesCategories All data fields in the PivotTable list are plotted.
chPlotAggregatesCharts
chPlotAggregatesFromTotalOrientation
chPlotAggregatesNone Only the first data field in the PivotTable list is plotted.
chPlotAggregatesSeries Multiple data fields will be plotted as series nested at the innermost level.
 

expression.PlotAllAggregates

expression   Required. An expression that returns a ChartSpace object.

Remarks

This property is relevant only when multiple fields have been added to the data area of the chart.