HomeGoogle DocsSpreadsheetHow to Create 3D Pie Chart in Google Sheets - With Pictures

How to Create 3D Pie Chart in Google Sheets – With Pictures

Published on

Pie Chart is one of the visually appealing charts among all other chart types with its filled colors. It’s a must to spice up your presentations and also to beautifully visualize your static data. You can very easily create 3D Pie Chart in Google Sheets.

Check our CHART SECTION to find all the necessary tutorials to create different types of charts including Line, Bar, Column, Geo Chart, Gantt, Combination chart, S Curve, Area, Sparklines etc.

Types of Pie Chart in Google Sheets

There are four different types of pie charts that we can use to visualize data in Google Sheets. They are;

  • Pie Chart
  • 3D Pie Chart
  • Doughnut Pie Chart
  • 3D Doughnut Pie Chart

All the above four Pie charts are similar in nature. Doughnut Chart is a little bit different in appearance as it comes with a hole in the center.

What is a Pie Chart?

You can use Pie Charts to show proportions of a whole. If you are unsure what type of chart you can create from your data, don’t worry. We have a chart selection tutorial on this site.

Tips to choose suitable chart.

How to Create a 3D Pie Chart in Google Sheets

The below Pie chart shows the proportion of the first language spoken in India. As you already know India is a country with different languages and custom. So I chose this data to create a Pie Chart.

The below sample data is taken from this source. I have taken this data only to give you step by step instruction on creating a 3D Pie Chart. I have no responsibility for the accuracy of data beyond that level.

pie chart sample data

Note: You can use IMPORTHTML function to import tables from any webpages to create your chart. I have detailed the tips to import tables from web pages on an earlier tutorial related to GEO chart.

Steps to Create 3D Pie Chart in Google Sheets

To create 3D Pie Chart in Google Sheets, follow the below simple steps.

First, select the entire data including the column label, that means from range “A1: B13”.

Go to the menu Insert -> Chart.

It will Insert a chart. It may not be of your type. So we need to set the chart type into Pie. To do that simply select the 3D Pie chart from the Chart Editor. In the below screenshot the third one is the 3D Pie Chart.

chart selection to create 3d pie chart

At this point, you can also select a Doughnut Chart or Simple Pie Chart instead. So you can consider this tutorial as an answer to your following questions related to Pie chart.

  1. How to create a simple Pie chart?
  2. How to create a Doughnut Pie chart?
  3. Tips to create a 3D Pie chart?
  4. Tips to create a 3D Doughnut Pie chart?

The fourth one, 3D Doughnut Pie chart, needs little explanation. I will explain it at later part of this tutorial.

Now back to the tips to create 3D Pie Chart. Upon selection of the chart type, your chart will automatically get visualized. That’s all. No need to do anything. Your finished 3D Pie chart will look like as below.

Finished 3D Pie Chart

If you want, check the customization part of the chart editor to change the color of your Pie chart or to do labeling etc.

Steps to Create a 3D Doughnut Pie Chart

As already told above, there are four types of charts that you can create or select from Google Sheets Chart Editor. But you can only see the option to create Pie, 3D Pie and Doughnut Pie chart in the Chart Editor.

To create a 3D Doughnut chart, follow the steps below.

  • Select the entire data range
  • Go to Insert -> Chart
  • From the Chart editor, select Doughnut Chart and then select 3D Pie Chart.

It will create a 3D Doughnut Pie Chart.

Conclusion:

You can move the chart to its own tab. To do that click on the chart and see the three vertical dots on the right side top. Click it and select “Move to own sheet”. Also please do check the publish option in File Menu.

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.

Creating Sequential Dates in Equally Merged Cells in Google Sheets

Do you know how to create sequential dates in equally merged cells across a...

Running Total By Month in Excel

This tutorial demonstrates how to calculate the running total by month in a range...

SORT and SORTBY – Excel Vs Google Sheets

While Excel offers the SORT and SORTBY functions for sorting a table, Google Sheets...

Get Top N Values Using Excel’s FILTER Function

When using the FILTER function in Excel to extract the top N values, it's...

More like this

Creating Sequential Dates in Equally Merged Cells in Google Sheets

Do you know how to create sequential dates in equally merged cells across a...

Interactive Random Task Assigner in Google Sheets

You have multiple tasks and multiple people. Here's a fun way to randomly assign...

Google Sheets Bar and Column Chart with Target Coloring

To color each data point in the column or bar chart according to the...

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.