Microsoft Office Tutorials and References
In Depth Information
PivotTables reveal patterns in your data. PivotCharts,
which you base on PivotTables, make patterns even
more apparent. Like all charts in Excel, PivotCharts
consist of elements such as chart type, axis, legend,
and data, all of which you can modify to meet your
needs. See Chapter 6 to learn more about working
When you create a chart from a PivotTable, you can
base your chart on summary statistics and you can
adjust the row and column layout. After creating your
chart, you can display the PivotTable Field List and
change the layout of your PivotTable. As you do, your
PivotChart changes automatically.
In addition, PivotCharts have options that regular
charts do not have. You can filter the data that
appears in your PivotChart. For example, if your data
is divided into multiple regions, you can easily specify
which regions appear in your PivotChart.
Click any cell in your PivotTable.
The PivotTable tools become
Click the Options tab.
Click PivotChart on the Tools
The Insert Chart dialog box
Click to select a chart type.
Click to select a chart sub-type.