Page 169 - Ms Excel Note and Workbook
P. 169
MICROSOFT EXCEL NOTE AND WORKBOOK
PivotCharts
PivotCharts are like regular charts, except they display data from a PivotTable. Just like regular
charts, you'll be able to select a chart type, layout, and style that will best represent the data.
To create a PivotChart:
In the example below, our PivotTable is showing a portion of each region's sales figures. We'll use a
PivotChart so we can see the information more clearly.
1. Select any cell in your PivotTable.
2. From the Insert tab, click the PivotChart command.
3. The Insert Chart dialog box will appear. Select the desired chart type and layout, then
click OK.
160 | P a g e
