Courses / PivotTables & PivotCharts
17. Creating a PivotChart
Inserting a PivotChart from a PivotTable and understanding the linked interaction between chart and table.
Excel for Office Work
Creating a PivotChart
A PivotChart is a chart that is directly linked to a PivotTable so visual filters, layout changes, and aggregations update both table and chart together.
"I want a chart that updates automatically when I slice and reorder my summary table."
Insert a PivotChart from a PivotTable to get a chart view that is driven by the same PivotTable fields, filters, and groupings; changes to one update the other.
"I want a chart that updates automatically when I slice and reorder my summary table."
Insert a PivotChart from a PivotTable to get a chart view that is driven by the same PivotTable fields, filters, and groupings; changes to one update the other.