Microsoft Office Tutorials and References
In Depth Information
Creating a PivotChart
Office 2007 provides the Office PivotChart Component to assist you in adding a chart to
a table or query. Using the Office PivotChart Component, you can create a PivotChart ,
an interactive chart that provides capabilities similar to a PivotTable. You can open a
table or query, switch to PivotChart view, add fields to the PivotChart’s drop areas, just as
you did when you created the PivotTable, and then filter the data in the PivotChart.
When you create a PivotChart, you can switch to PivotTable view to view and further
filter the charted data in a PivotTable. Likewise, after creating a PivotTable, you can
switch to PivotChart view to view and further filter the tabular data in a PivotChart.
You’ll switch to PivotChart view to show Sarah the PivotChart of the PivotTable data.
To switch to PivotChart view:
1. Right-click the qryInvoicesByItem tab, and then click PivotChart View on the
shortcut menu to switch to PivotChart view. See Figure 8-33.
Filtered PivotTable data in a PivotChart
category axis labels
A PivotChart contains the following basic components:
•The plot area provides a background for the data markers and gridlines. A data marker
is a bar, dot, segment, or other symbol that represents a single data value. The data
field , which is the Sum of InvoiceAmt field in Figure 8-33, identifies which values the
data markers represent and identifies each value displayed as a value axis label . Each
gridline , which appears in Figure 8-33 as one of the horizontal lines in the plot area,
makes it easier to see the values represented by the data markers.