Summary  
This chapter covers how to link and configure pivot chart visualizations to underlying pivot table summaries, automatically mapping fields to axes, series, values, and filters so that any change in the data model instantly updates the chart.

General domain of usage  
Business analytics dashboards

A regular chart is connected to a fixed cell range. A pivot chart is connected to a pivot table. This distinction changes everything about how it behaves: when you change the pivot table — adding a field, applying a filter, changing a grouping — the chart updates immediately to reflect the new structure. There is no data range to manually adjust, no series to redefine.

Route 2 — from the source data directly

1. Click anywhere inside the pivot table.
2. PivotTable Analyze tab → PivotChart.
3. Choose the chart type → click OK. Excel generates the chart from the current pivot table structure instantly.


1. Click anywhere inside the source data table.
2. Insert tab → PivotChart.
3. Excel creates a new pivot table and pivot chart together on a new worksheet. Configure the fields in the PivotTable Fields panel.

### How Fields Map to the Chart
1. **Rows** → X-axis labels (Values appear along the horizontal axis — months, categories, stores);
2. **Columns** → Series / legend (Each unique value becomes a separate line or bar group);
3. **Values** → Y-axis / bar height (Controls what is measured — height of bars or position of points);
4. **Filters** → Chart filter (Filtering the pivot table immediately narrows what the chart shows).


Adding new rows to the source table does not update the pivot chart automatically. You must refresh the pivot table — which simultaneously refreshes the chart. 

**PivotTable Analyze → Refresh**  | right-click pivot table → **Refresh**

Note

1. **Create a PivotChart (Column)**

   Click anywhere inside your PivotTable.
Go to **PivotTable Analyze → PivotChart** and select **Clustered Column**, then click OK.

3. **Change the perspective**

   In the PivotTable, move **Category** to Columns and **Store** to Rows (or reverse them).

4. **Create a trend view (Line Chart)**

   Ensure **Order Date (grouped by Month)** is in Rows and **Revenue** remains in Values.
Insert a **Line PivotChart**.

5. **Apply a filter**

   Drag **Salesperson** into Filters and select one (e.g., Emily Carter).

6. **Move the chart to a dashboard**

   Select the chart and move it to a new or clean worksheet.


You create a PivotChart showing Revenue by Category, then move Category from Rows to Columns. The chart changes orientation, but totals remain the same. What does this confirm?

Learn Excel the fun way — step by step, you'll go from basic data handling to building charts and dashboards that actually make sense. You'll learn how to organize messy data, use formulas with confidence, and turn numbers into clear insights.


Messy spreadsheets turn into clean, structured data. Tables, sorting, filtering, and smart input rules help keep everything accurate and easy to work with.

Raw data becomes clear and readable. Formatting, alignment, and conditional highlights make important insights stand out instantly.

Numbers start working for you. Formulas, functions, and logical conditions handle calculations, automate tasks, and solve real problems.

Data turns into visuals that tell a story. Charts, sparklines, and design improvements make information easy to understand at a glance.

Big datasets become simple summaries. PivotTables, interactive controls, and dashboards bring everything together into clear, dynamic insights.

Pivot Charts

Creating a Pivot Chart

How Fields Map to the Chart