Excel PivotTablesLesson 69Free preview

Excel PivotChart

This lesson is part of Excel · All levels

Summary

A pivot chart is a chart that is directly connected to a pivot table, so that the filter on the pivot is drawn on the chart and vice versa. You can choose a chart type like a column or a line and then add the legend and the label data. PivotChart makes it easy to present dynamic reports without re-charting every time the data changes.

Key points

PivotChart is tied to the PivotTable and synchronized with the filter
It's made by analyzing the PivotTable > PivotChart
Types of charts common: column, line, bar, and area
Chart elements like legend and data label can be customized

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.