Pivot charts are an extension of pivot tables.
To illustrate this connection, I’ll start by creating a new pivot table and pivot chart.
The first thing to notice is that both pivot tables and pivot charts change Excel’s interface when selected.
When I click away, this list disappears, and when I click back it reappears.
Row Labels are called Axis fields, and Column Labels are referred to as Legend Fields.
This is just to make it easier to understand how pivot table fields are connected to the chart.
Any change I make the to the pivot chart is reflected in the pivot table and vice versa.
In most respects, a pivot chart is just like any other chart.
you might format axes, and remove elements, change formatting, and so on.
You’ll see the data has been stored in the SERIES formulas in the chart.
