About this lesson
Creating Pivot Charts out of a Pivot Table.
Multiple versions of this lesson are available, choose the appropriate version for you:
Creating PivotCharts out of a PivotTable.
Where/when to use the technique
When you want a visual summary of your data.
Creating a PivotChart
- Select a cell inside your PivotTable
- Excel 2010: PivotTable Tools > Options > PivotChart
- Excel 2013: PivotTable Tools > Analyze > PivotChart
- Choose a chart type to start with
- Modify your PivotTable to perfect the display
- Can be done via the built in filter icons
- Can also be done via slicers hooked to the PivotTables
Removing the chart filter buttons
- Select the PivotChart > PivotChart Tools > Analyze > Field Buttons > Hide All
- Every PivotChart is based on a PivotTable
- Modifying the PivotChart modifies the underlying PivotTable
- PivotTables don’t play well with combination charts (one chart type takes over on slicing)
- Create the PivotTable that drives your PivotChart
- Create the PivotChart
- Attach slicers to the PivotTable
- Optionally cut the chart/slicers to a new worksheet
- Hide the PivotTable (or the entire worksheet)
Lesson notes are only available for subscribers.