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 Guide Prashanth KV brings a wealth of experience in Google Sheets and Excel, cultivated through years of work with multinational corporations in Mumbai and Dubai. As a recognized Google Product Expert in Docs Editors, Prashanth shares his expertise through insightful blogging since 2012. Explore his blog for practical tips and guidance on maximizing your spreadsheet skills.

Hierarchical Numbering Sequences in Excel

Creating hierarchical numbering sequences in an Excel spreadsheet can significantly improve the way you...

How to Easily Repeat a Sequence of Numbers in Excel

Excel offers multiple ways to accomplish tasks, and the simplicity of each approach depends...

Create a Sequence of Dates at Every Nth Row in Excel (Dynamic Array)

Would you like to create a sequence of dates in every nth row in...

XMATCH Row by Row: Finding Values Across a Range in Google Sheets

Using the BYROW function with XMATCH in Google Sheets allows us to match values...

More like this

XMATCH Row by Row: Finding Values Across a Range in Google Sheets

Using the BYROW function with XMATCH in Google Sheets allows us to match values...

Limit Formula Expansion to a Specific Row in Google Sheets

In this tutorial, I’ll explain how to limit the expansion of an array formula...

3-D Referencing Structured Data Tables in Google Sheets

When you have several tables within a single sheet—not across multiple sheets in a...

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.