New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Charts›Create a pivot chart

Google Sheets · Verified tutorial

Create a pivot chart in Google Sheets

Create a pivot table on a new sheet from A1:D6 with Region in Rows and Revenue in Values summarized by SUM. Then create a column chart from the complete pivot result A1:B5. Do not change the source data.

Verified by PhilisJuly 15, 2026About 60 seconds

Quick answer

Create a pivot table on a new sheet from A1:D6 with Region in Rows and Revenue in Values summarized by SUM. Then create a column chart from the complete pivot result A1:B5. Do not change the source data.

Step-by-step

1

Select the targetCreate a pivot table on a new sheet from A1:D6 with Region in Rows and Revenue in Values summarized by SUM.

2

Apply the changeThen create a column chart from the complete pivot result A1:B5.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

A pivot table groups Revenue by Region, and a column chart visualizes the complete pivot result.

Common mistake

Changing the source values while applying the formatting or structure change.

Troubleshooting

Re-select A1:D6 and repeat the final action. A pivot table groups Revenue by Region, and a column chart visualizes the complete pivot result.

Example spreadsheet data

This is the clean fixture used for the verified run.

Region	Owner	Category	Revenue
North	Anna	Software	120
South	Ben	Services	180
North	Cara	Services	240
West	Dev	Software	210
South	Eva	Software	160

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Create a pivot table on a new sheet from A1:D6 with Region in Rows and Revenue in Values summarized by SUM.
Apply the change. Then create a column chart from the complete pivot result A1:B5.
A pivot table groups Revenue by Region, and a column chart visualizes the complete pivot result.