Pivot Charts — Turning Pivot Summaries into Live Visuals

A pivot chart is a chart built directly from your pivot table — and the two stay in sync. Change the pivot and the chart changes; filter the chart and the pivot filters too. This tutorial covers creating, choosing, and controlling pivot charts.

Table of Contents

1. What is a Pivot Chart?
2. Create a Pivot Chart
3. Choose the Right Chart Type
4. Change Chart Type & Style
5. Filter an Existing Pivot
6. Combine Charts with Slicers
7. Pivot Chart vs Regular Chart
8. Do It with AI

What is a Pivot Chart?

A pivot chart is a chart that reads from a pivot table instead of from raw cells. Because of that link, every summary your pivot shows is mirrored in the chart automatically.

Why it is useful: you get both a number summary and a picture of it with zero extra work. Drag fields in the pivot and the chart redraws itself.

Create a Pivot Chart

1. Click anywhere inside your existing pivot table.
2. Go to the PivotTable Analyze tab.
3. Click PivotChart.
4. Pick a chart type (start with Column).
5. Click OK.

A chart appears next to your pivot, and a PivotChart Fields pane opens on the right — it looks exactly like the pivot's field pane.

Simple explanation: the chart and the pivot share the same field layout. Rows in the pivot become the chart's categories; Values become the bars or lines.

Choose the Right Chart Type

For the sample sales data, a Line chart on monthly revenue shows the trend clearly, while a Column chart on region revenue compares regions.

Note: pie charts only handle a single data series. If your pivot has both categories and months, switch to a column or line chart instead.

Change Chart Type & Style

• Change type: right-click the chart → Change Chart Type → pick a new one.
• Move/resize: drag the chart, or hold Alt while dragging to snap it to the cell grid.
• Format: use the Chart Design and Format tabs — change colors, fonts, add data labels.
• Title: click "Chart Title" and type your own.

Best practice: remove gridlines and heavy borders on dashboard charts. Clean charts read faster.

Filter an Existing Pivot

Because chart and pivot are linked, you can filter from either side:

• Filter the pivot (dropdown, slicer, timeline) → the chart updates.
• Click the funnel Chart Filters button at the chart's top-right → the pivot updates too.

This two-way link is what makes pivot charts feel "live."

Combine Charts with Slicers

Slicers (from Tutorial 2) work directly on charts:

1. Select the chart (or its pivot).
2. Insert tab → Slicer → pick a field like Region.
3. Click buttons on the slicer.

The chart redraws instantly for the selected region. This is the building block of an interactive dashboard.

Pivot Chart vs Regular Chart

Common mistake: deleting the pivot because you "only need the chart." The pivot chart depends on it and will vanish. If you want a standalone picture, copy the chart with Paste Special → Picture or rebuild it as a regular chart.

Do It with AI

• Copilot in Excel: select the pivot and type Create a line chart of revenue by month. Copilot builds a chart linked to your pivot. Follow up with Make it a column chart. to change the type.
• ChatGPT: prompt My pivot has Date and Revenue. Which chart best shows the trend over months, and which best compares regions? for a fast, explained choice — or Write the steps to change a pivot chart from column to line in Excel. for step-by-step.

AI picks the chart and writes the steps, but you still choose the story it tells: a line for trends, a column for comparisons.