What Is Pivot Chart In Google Sheets?
Pivot chart in Google sheets helps users create data into a visual form including complex data and trends.
This inbuilt function is similar to that of pivot chart in Excel and is used to create, present data into visually appealing charts.
For example, consider the below table showing sales of an organization with units, price per unit and total sales.
Now, let us learn how to create Pivot chart.
The steps are:
Step 1: First, we need to create a Pivot Table in Google sheets.
Step 2: Next, select the Pivot Table and click on Insert > Chart.
Step 3: The Chart Editor tab appears on the right side.
Step 4: Select Stacked Column chart under the Setup tab, in the Chart Type option.
Step 5: We can see the Pivot Chart as shown in the below image.
Likewise, we can use Google sheets to create Pivot chart.
In this article, let us learn how to create Pivot chart in Google charts with detailed examples.
Table of contents
Key Takeaways
- Google Sheets Pivot chart helps users create visually appealing charts which is easy to understand.
- Remember, to create a Pivot chart in Google sheets, we need to create a Pivot Table for the same data.
- To create a Pivot Table in Google sheets, we need to
- Select the data and click on Insert > Pivot Table.
- Enter the cell range and the sheet preferences where we want to create our Pivot table (New or Existing sheet)
- Select the field settings and filters to create our Pivot table.
- Finally, we can create a chart by navigating to Insert > Chart > Stacked Column.
How To Create Pivot Chart In Google Sheets?
As mentioned already, we need to have a Pivot Table to create Pivot chart. So, let us learn how to create PivotTable.
The following highlights the steps used to create Pivot Table.
- First, let us insert the table (data) we want to create a Pivot Table.
- Select the table range for which we want to create the Pivot table.
- Next, select the table and click on Insert > Pivot Table.
- The Create Pivot table window pops up.
- Select the table range for which we want to create the Pivot table and then, click on New or Existing sheet. Click Create.
- The Pivot Table Editor tab appears on the right side.
- Here, we need to select the values we want to include in our Pivot Table such as Rows, Columns, Values, and Filters.
- To include the values, we can simply click on one of the options (Rows, Columns, Values, and Filters). As soon as we click, we can see a dropdown option with all the data present in the table and choose the values.
Our Pivot table is now ready.
- Using the Pivot table in Google sheets, we can easily create Pivot chart by clicking on Insert > Chart.
- The Chart Editor tab appears on the right side.
- Select Stacked Column chart under the Setup tab, in the Chart Type option.
We can see the Pivot chart for the data.
Likewise, we can create Pivot chart.
Examples
Example #1
Consider the below table showing the sales of various products along with the order date, name of the salesmen, number of units ordered, price of a unit, and total sales in the cell range A1:F11.
Now, let us learn how to create Pivot chart.
Let us first create a Pivot Table in Google sheets for the given data.
The steps are:
Step 1: First, let us insert the table (data).
Step 2: Select the table range for which we want to create the Pivot table.
Step 3: Next, select the table and click on Insert > Pivot Table.
Step 4: The Create Pivot table window pops up.
Step 5: Select the table range for which we want to create the Pivot table and then, click on New or Existing sheet. Click Create.
Step 6: Next, select the table and click on Insert > Pivot Table.
Step 7: The Pivot Table Editor tab appears on the right side.
Step 8: Here, we need to select the values we want to include in our Pivot Table such as Rows, Columns, Values, and Filters.
Step 9: To include the values, we can simply click on one of the options (Rows, Columns, Values, and Filters). As soon as we click, we can see a dropdown option with all the data present in the table and choose the values.
Our Pivot table is now ready.
Step 10: Using the Pivot table in Google sheets, we can easily create Pivot chart by clicking on Insert > Chart.
Step 11: The Chart Editor tab appears on the right side.
Step 12: Select Stacked Column chart under the Setup tab, in the Chart Type option.
We can see the Pivot chart for the data.
Likewise, we can create Pivot chart.
Example #2
Again, let us use the same data.
Now, try to create a different Pivot chart by including other values.
The steps are:
Step 1: Since we have already created a Pivot table for the same data, we can click on the Pivot Table directly.
Step 2: The Pivot Table Editor window appears on the right side.
Step 3: Here, let us add the values such as Unit Price, Total Sales etc.,
Step 4: We can see the changes readily in the Pivot Table.
Step 5: Now, since our Pivot table is updated, let us create a Pivot chart for the same data in Google sheets.
Step 6: Using the Pivot table in Google sheets, we can easily create Pivot chart by clicking on Insert > Chart.
Step 7: The Chart Editor tab appears on the right side.
Step 8: Select Stacked Column chart under the Setup tab, in the Chart Type option.
We can see the Pivot chart for the data as shown in the below image.
From this example, it is evident that the Pivot charts can be altered or a new dimension of Pivot chart can be created based on the filters and values we add in the Pivot Table for our data.
Advantages Of Pivot Chart In Google Sheets
Users know the advantages of using Pivot chart when compared with normal charts in Excel. Let us learn the advantages of using Pivot Chart.
They are:
- Users can easily find and identify specific values from large datasets using the filters and settings readily available in the Pivot table editor in Google sheets.
- Financial experts can use this feature to create, learn, and visually present data.
- This chart type is inbuilt and thus, we can create Pivot chart in Google sheets for the Pivot Table and edit whenever possible are some of the advantages of Pivot Chart in Google Sheets.
Important Things To Note
- Google Sheets Pivot chart shows the content in the Pivot table in a visual format.
- Therefore, we need to create a Pivot table in Google sheets for the data which we wish to create a Pivot chart.
- Remember to include the field settings properly to make sure our Pivot chart is correct and error free.
Frequently Asked Questions (FAQs)
For example, consider the below table showing sample sales of an organization with units, price per unit and total sales.
Now, let us learn how to create Pivot chart in google sheets.
The steps are:
Step 1: First, we need to create a Pivot Table in Google sheets.
Step 2: Next, select the Pivot Table and click on Insert > Chart.
Step 3: The Chart Editor tab appears on the right side.
Step 4: Select Stacked Column chart under the Setup tab, in the Chart Type option.
Step 5: We can see the Pivot Chart as shown in the below image.
Likewise, we can use Google sheets to create Pivot chart.
• First and foremost, we need to create a Pivot Table in Google sheets prior as we can create a Pivot chart only with the Pivot table.
• The field settings and filters we use to create our Pivot table is what shows up in the Pivot chart. Therefore, we need to be cautious and select the filters before creating Pivot Chart.
In Google sheets, removing filters is as easy as creating a Pivot table. Simply click on the Pivot table Editor and remove the filters by clicking on the Delete symbol.
Download Template
This article must be helpful to understand Pivot Chart In Google Sheets, with its formula and examples. You can download the template here to use it instantly.
Recommended Articles
Guide to What Is Pivot Chart In Google Sheets. Here we explain how to use Pivot Chart In Google Sheets with examples and points to remember. You can learn more from the following articles. –
Leave a Reply