Output charts as tables

All chart types now support the drawing of the data as tables via the Draw As property. The tables drawn are "pivot" tables that may contain subtotals. This terminology and rules are applied:

The columns of the tables are either of type Dimension (the data items that are used to group values ) or of type Value (see Mapping of Chart properties).
Values are aggregated or totaled by the Dimension.
Dimension columns precede Value columns in the table.
The order of the Dimensions specifies the order of the data.
Subtotals are generated for each Dimension except the rightmost.

Mapping of chart properties

Map chart - the Key property is mapped to a Dimension column, and the Value property to a Value column.
Category chart - the Category Key property and the key property are mapped to Dimension columns, and the value property to a Value column.
XY chart - the Series Title property is mapped to a Dimension column and the X and the Y properties are mapped to Value columns.

There are three types of tables: Table, SortedTable, and AggregatedTable.