How to Create a 3D Pie Chart in Google Sheets

Published on

If you arrange your data properly, you can easily create a 3D pie chart in Google Sheets with just three steps.

A pie chart is circular in shape and two-dimensional (flat), divided into slices to represent the proportions of a whole. A 3D pie chart adds a three-dimensional effect but is essentially the same in terms of data representation.

Pie charts are often part of dashboard reports in Google Sheets. They are one of the best options for visually representing survey results, budget allocations, and more.

Pie charts are simple to read and understand, making them one of the most popular data visualization tools in Google Sheets.

However, one of the drawbacks of pie charts is the number of categories. More categories make the slices with proportionally less quantity very small, and they may miss labels.

If you have more than 6 categories, it is suggested to switch to a bar chart.

In this tutorial, we will see how to properly arrange data and create a 3D pie chart in just a few steps.

Steps to Create a 3D Pie Chart in Google Sheets

Arrange your data in two columns where the first column contains the categories (acts as labels) and the second column contains corresponding numerical values representing the amount for each category.

For example, we’ll use data on the number of native speakers of five Indian languages. The first column will list the languages (e.g., Hindi, Bengali), and the second column will contain the number of speakers for whom each language is their primary language.

Steps:

  1. Select the Range: Select the range A1:B.
  2. Insert the Chart: Click the Insert menu and select Chart.
  3. Change Chart Type: It will probably insert a 2D pie chart by default. Within the Chart Editor sidebar panel, click the drop-down under Chart Type and select 3D Pie Chart.
Example of a 3D pie chart created in Google Sheets

By following these steps, you can create a 3D pie chart in Google Sheets.

Exploding a 3D Pie Chart in Google Sheets

You can separate each slice from a pie chart to bring focus, a technique called pie chart explosion. The exploded slices appear as if they were cut out from the pie, and you can adjust how far each slice should be moved from the center.

Here’s how to explode a 3D pie chart in Google Sheets:

  1. Double-click on the chart to open the Chart Editor sidebar panel.
  2. Navigate to the Customize tab.
  3. Click on “Pie Slice” and select the slice that you want to move outwards.
  4. Choose a default distance from the center (0% to 100%) or enter your value.
Exploding a 3D Pie Chart in Google Sheets

By following these steps, you can effectively explode slices in a 3D pie chart in Google Sheets to highlight specific data points.

Please note that this may disable some legend options under Customize > Legend, leaving you with the options Top, Left, Bottom, and Right.

Understanding Legends and Slice Labels

When creating a 3D pie chart, you might often be confused with legends and slice labels.

Slice labels appear within the slices and can display actual values rather than percentages.

To show actual values within slices, click on Customize > Pie Chart and select “Value” under slice labels.

However, keep in mind that with a large number of data points or limited space within the slices, some values might not be visible.

Legends, on the other hand, serve a different purpose. You can display them outside the chart. They help identify each slice with color codes or connecting lines.

Resources

Prashanth KV
Prashanth KV
Your Trusted Google Sheets and Excel Expert Prashanth KV is a Diamond Product Expert in Google Sheets, officially recognized by Google for his contributions to the Docs Editors Help Community and featured in the Google Product Experts Directory. Explore his blog to learn advanced formulas, automation tips, and problem-solving techniques to elevate your spreadsheet skills.

Calculate Trip Days by Month (Start, End, and Full Days) in Google Sheets

If you're managing business travel in Google Sheets, you may need to calculate how...

Mode of Comma-Separated Numbers in Excel (Dynamic Array)

There is no dedicated function in Excel to directly find the mode of comma-separated...

How to Find Mode of Comma-Separated Numbers in Google Sheets

Working with comma-separated numbers inside a single cell is a common scenario in Google...

How to Count Merged Cells in Google Sheets (and Get Their Size)

Sometimes, you may have blocks of merged cells in a column or row. But...

More like this

Calculate Trip Days by Month (Start, End, and Full Days) in Google Sheets

If you're managing business travel in Google Sheets, you may need to calculate how...

How to Find Mode of Comma-Separated Numbers in Google Sheets

Working with comma-separated numbers inside a single cell is a common scenario in Google...

How to Count Merged Cells in Google Sheets (and Get Their Size)

Sometimes, you may have blocks of merged cells in a column or row. But...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.