TcxPivotGridChartConnection Class

Represents an object that visualizes the data displayed in ExpressPivotGrid controls using unbound ExpressQuantumGrid Chart Views.

Declaration

TcxPivotGridChartConnection = class(
    TcxCustomComponent,
    IcxPivotGridListener
)

Remarks

This component allows you to create charts on summary data displayed in pivot grid data cells. These charts include:

Static Charts. These charts are created using all cross cells displayed in the pivot grid.

Dynamic Charts. These charts are created using only the selected data cells. If the pivot grid’s OptionsSelection.MultiSelect option is enabled, end-users can create dynamic charts, and combine various values in charts by selecting non-contiguous cell ranges while holding down the Ctrl key. In addition, you can allow end-users to select only certain data cells (cross cells, total cells, and/or grand total cells) using the pivot grid’s OptionsSelection.IncludeCells property.

Usage

Drop a TcxPivotGridChartConnection component on a form and link it to the pivot grid and unbound Chart View via the PivotGrid and GridChartView properties, respectively. After this, choose source data for default categories, and their scope using the SourceForCategories and SourceData properties. At runtime, chart categories and series will be created automatically, based on specified data cells and corresponding column/row values.

You can customize the specified scope of source data cells on the fly and provide custom labels for series by handling the OnGetDataCells and OnGetSeriesDisplayText events.

Important

The ExpressQuantumGrid is not a part of the ExpressPivotGrid Suite, and must be installed separately. Please review the ExpressQuantumGrid’s Chart View documentation for more information.