Summary  
This chapter introduces dynamic data binding between a summarized data model and a visualization component, so that any reconfiguration of fields, filters, or groupings in the model automatically updates the chart.

General domain of usage  
Interactive business dashboards and reporting.

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?

Lær Excel på en underholdende måde — trin for trin går du fra grundlæggende datahåndtering til at opbygge diagrammer og dashboards, der giver mening. Du lærer at organisere ustrukturerede data, bruge formler med sikkerhed og omsætte tal til klare indsigter.


Rodede regneark omdannes til rene, strukturerede data. Tabeller, sortering, filtrering og intelligente inputregler hjælper med at holde alt nøjagtigt og nemt at arbejde med.

Rådata bliver klare og læsbare. Formatering, justering og betingede fremhævninger får vigtige indsigter til straks at træde frem.

Tal begynder at arbejde for dig. Formler, funktioner og logiske betingelser håndterer beregninger, automatiserer opgaver og løser reelle problemer.

Data omdannes til visuelle elementer, der fortæller en historie. Diagrammer, minidiagrammer og designforbedringer gør information letforståelig ved første øjekast.

Store datasæt bliver til enkle oversigter. Pivottabeller, interaktive kontroller og dashboards samler det hele til klare, dynamiske indsigter.

Pivot Charts

Creating a Pivot Chart

How Fields Map to the Chart

Task