The eXPivot control allows you to redefine the table portion of the control, enabling the display of custom views like a Graph control. The ControlID property specifies the program identifier of the control used to define the custom view. For instance, if the ControlID property is set to "exontrol.graph", the eXPivot control automatically uses the Data to update the graph charts based on the current arrangement. If the PivotBarVisible property includes the exPivotBarSingleAggregate flag, it configures the pivot bar to use a single aggregate function with separate row, column, and aggregate sections, enabling the single-aggregate mode. The ShowBranchRows property on exBranchColumns indicates that a new column is added for each pivot row column, without displaying the +/- buttons. The OleEvent event occurs whenever the custom view fires an event. The ViewChange event is triggered whenever there is a change in the control's view.

The following snippet of code displays the eXGraph instead of the pivot table: