From pivot table to chart without losing your mind
Pivot tables are optimised for reading on screen, which means merged label cells, subtotal rows and a grand total at the bottom. Every one of those breaks a chart import.
Step 1: paste as values
Copy the pivot output and paste it as values into a blank sheet. You now have a static rectangle instead of a live pivot that reshapes itself when you touch it.
Step 2: delete every total
Subtotal rows and the grand total become chart categories if you leave them in, producing that one enormous bar. Delete them; a chart can compute its own totals.
Step 3: fill down the labels
Pivots show a row label once and leave the cells below blank. Fill those down so every row is self-describing, which is what a long-format import expects.
Step 4: sanity-check one number
Pick a single cell and verify it against the source. Pivot reshaping is exactly where silent double counting sneaks in, and one check catches it.
Paste the cleaned range →If you do this monthly, save the cleaned sheet as a template. The reshape is identical every time and takes two minutes once the layout is fixed.
Frequently asked
Why does my pivot table not chart correctly?
Because it contains subtotals, a grand total and merged label cells. Charting tools read those as data, producing phantom categories.
Should I chart directly from a pivot table?
Only inside the same spreadsheet app. For anything exported, paste as values and clean the range first.