Goal
You’ll be able to create a PivotChart directly from a PivotTable, and understand the genuinely important connection between the two — since they stay linked in a way that affects how you should think about editing either one.
Learn
A PivotChart is a chart built directly from a PivotTable’s summarized data, created via Insert tab → PivotChart (or by selecting an existing PivotTable and inserting a chart from it). It uses the exact same summarization and grouping logic as its source PivotTable, visualized as an actual chart instead of a table of numbers.
The genuinely important connection: a PivotChart stays linked to its source PivotTable. Changing the PivotTable’s layout (dragging a field from Rows to Columns, for example) automatically updates the connected PivotChart to match — you don’t need to separately rebuild the chart every time you reorganize the underlying PivotTable.
This linkage also means a PivotChart follows the same refresh behavior covered in the previous lesson: if new source data is added, both the PivotTable and its linked PivotChart need that same manual Refresh to reflect the new data — refreshing one typically refreshes the other automatically, since they share the same underlying data connection.
Interacting with a PivotChart’s own filter buttons (which appear directly on the chart itself) also filters the connected PivotTable simultaneously, and vice versa — they’re genuinely two connected views of the exact same underlying summarized data, not two independent, separately-maintained objects.
Decision Task
You reorganize your PivotTable by moving the “Product” field from Rows to Columns. Before reading on: does the connected PivotChart update automatically to reflect this new arrangement, or does it need to be manually rebuilt?
Show Answer
It updates automatically — a PivotChart stays genuinely linked to its source PivotTable, so any layout change to the PivotTable (like moving a field between Rows and Columns) automatically reflects in the connected chart too, with no manual rebuilding needed.
Common Mistake
Treating a PivotChart and its source PivotTable as two separate, independently-maintained objects that each need their own manual updates. They’re genuinely linked — changes to one’s layout or a needed data refresh typically apply to both simultaneously, since they share the exact same underlying summarized data connection.
Practice Questions
1. What is a PivotChart built directly from?
Show Answer
A PivotTable’s already-summarized data.
2. If you rearrange a PivotTable’s fields, does the connected PivotChart need to be separately rebuilt?
Show Answer
No — it automatically updates to match the PivotTable’s new arrangement, since they stay linked.
3. If new source data is added, does refreshing just the PivotTable also update the connected PivotChart?
Show Answer
Generally yes, since they share the same underlying data connection and refresh behavior.
4. True or False: filtering directly on a PivotChart has no effect on its connected PivotTable.
Show Answer
False — filtering one typically filters the other simultaneously too, since they’re connected views of the same underlying summarized data.
5. Where would you go to create a PivotChart from an existing PivotTable?
Show Answer
The Insert tab, selecting PivotChart while the PivotTable (or its data) is selected.
Try It Yourself
Without looking back, explain in your own words the core relationship between a PivotTable and a PivotChart built from it.
Show Answer
They are genuinely linked, connected views of the exact same underlying summarized data — rearranging or refreshing one typically applies to the other automatically too, rather than being two separate, independently-maintained objects that each need their own separate updates.
Quick Check
1. What is a PivotChart based on?
Show Answer
A PivotTable’s summarized data.
2. Does a PivotChart automatically update when its source PivotTable’s layout changes?
Show Answer
Yes, since they stay linked.
3. Does refreshing a PivotTable typically also refresh its connected PivotChart?
Show Answer
Yes, generally, since they share the same underlying data connection.
4. Does filtering a PivotChart affect its connected PivotTable?
Show Answer
Yes, typically simultaneously, since they’re connected views of the same data.
5. Where do you create a PivotChart from an existing PivotTable?
Show Answer
The Insert tab.