How to Create Pivot Charts in Google Sheets

This guide will explain how to create pivot charts in Google Sheets.

Pivot charts are a powerful data visualization and analytics feature that allows you to quickly create charts from specific slices of your dataset.

By using pivot charts, you transform raw data into meaningful charts like bar graphs, line graphs, and more without needing to manually calculate summaries or reorganize your data. 

While PivotCharts are not a natively supported feature in Google Sheets, we can still create standard Google Sheets charts that use data from a Pivot Table.

In this guide, we will provide a step-by-step tutorial on how to create your own pivot charts in Google Sheets. We’ll cover how to set up a pivot table from a dataset and how to create a chart that connects to that pivot table.

A Real Example of Creating Pivot Charts in Google Sheets

Let’s explore a simple example of where we can create a pivot chart in Google Sheets.

sample data to analyze

In the table above, we have a dataset of T-shirt orders. We want to visualize the number of T-shirt orders each store branch received and the corresponding T-shirt size distribution.

create pivot table

A pivot table allows us to aggregate our data to create a summary of our orders. In the table above, we grouped our orders by the shirt_size column to determine the distribution of our orders by shirt size.

We can use the pivot table as our source data for a pivot chart to create a more interactive and flexible visualization of our data. Using a pivot chart allows us to filter through our data with an existing pivot table and select what data points to visualize. 

pivot chart example

We can edit the pivot table filters to adjust our chart to show the data we want to look at

pivot chart in google sheets adjusted

In the example above, we’ve changed our pivot chart to only show orders coming from a specific branch.

Click on the link below to create your own copy of our examples.

Head to the next section to read our step-by-step tutorial on how to create a pivot chart in Google Sheets.

How to Create Pivot Charts in Google Sheets

  1. First, we’ll need to create a pivot table from our source dataset. Select any cell in your table and use the keyboard shortcut Ctrl + A to select the entire table.
    select dataset
  2. While selecting your dataset, click on the Pivot table option under the Insert menu.
    insert pivot table
  3. In the Create pivot table dialog box, select whether you want to add the pivot table in a new sheet or an existing sheet. Click on Create to proceed.
    create pivot table
  4. In the Pivot table editor, select the rows, columns, values, and filters you want to set for your Pivot Table.
    adjust pivot table setupIn this example, we will create a pivot table that displays the number of orders placed for each shirt size. We’ll also add a filter to allow us to filter by which branch the order came from.

  5. We’ll use the pivot table as a data source for the pivot chart. Select the entire pivot table using the keyboard shortcut Ctrl + A.
    select pivot table
  6. In the Insert menu, select the Chart option to add a new chart based on our selected table.
    add pivot chart
  7. Use the Chart editor to modify the look of your Pivot chart.
    pivot chart exampleIn our example, we’ve used a bar graph to compare the number of orders for each shirt size.

  8. Since the data source of our Pivot Chart is a Pivot Table, our chart will adjust to any modifications.
    pivot chart in google sheets adjusted
    In this example, we were able to filter our Pivot Table data to compare orders from a specific branch.

These are all the steps you need to start creating pivot charts yourself in Google Sheets.

FAQs

  1.  What should I do if my Pivot Chart isn’t reflecting changes made in the Pivot Table?
    First, ensure that the Google Sheets chart is linked to the pivot table. If it is, but changes aren’t reflecting, try refreshing the document through your browser options.

  2. How do I change the type of chart used for a pivot table in Google Sheets?
    After creating a chart from a pivot table, you can change the chart type by selecting the chart and then clicking on the “Chart editor” pane. Here, you can choose from various chart types (line chart, bar graph, pie chart, and so on) to best represent your data.

To learn more about other applications for pivot tables in Google Sheets, you can read our post on how to summarize Google Sheets data with a Pivot Table report.

That’s all for this guide! Be sure to check out our library of spreadsheet resources, tips, and tricks! 

Get emails from us about Excel.

Our goal this year is to create lots of rich, bite-sized tutorials for Excel users like you. If you liked this one, you'd love what we are working on! Readers receive early access to new content.

0 Shares:
Leave a Reply

Your email address will not be published. Required fields are marked *

You May Also Like