How to Make a 3D Pie Chart in Google Sheets (With Quick Steps)

“A picture is worth a thousand words”. Charts, Graphs, or Diagrams are important for better presentation, and for a better understanding of a specific topic. They present information visually. Since trends and correlations may sometimes be seen clearly on charts, graphs, or diagrams, they can make comparing different sets of data much simpler. And when it comes through a 3D visualization, the understanding process becomes much more simpler. In this article, we have demonstrated step-by-step procedures to make a 3D pie chart in Google Sheets.


A Sample of Practice Spreadsheet


Step-by-Step Process to Make a 3D Pie Chart in Google Sheets

Making a 3D pie chart is easy. Just go through the following steps to make a 3D pie chart in Google Sheets.


Step 1. Make a Dataset

First of all, to make a 3D pie chart, you will need a dataset. For example, we will use the following dataset here. The dataset represents the 2011 Ballon d’Or list with the players winning probabilities.

Step-by-Step Process to Make a 3D Pie Chart in Google Sheets


Step 2. Insert Chart

  • First, select Cell range B5:C11, go to the toolbar menu and select Insert. Then select Chart.

  • Or you can simply use the “Insert chart” option from the toolbar.

how to make 3D pie chart in google sheets

  • After that, a pie chart will appear on your dataset.


Step 3. Change Chart Type

  • At the top right of the pie chart select the vertical ellipsis (⋮) option then select “Edit chart”.

Changing chart type to make 3D pie chart in google sheets

  • Or you can simply left-click on the chart twice.
  • A sidebar will appear on your dataset titled “Chart editor”.

  • In the sidebar, from the Setup section, select the Drop down menu of chart type and then select “3D pie chart”.

creating 3D pie chart in google sheets

  • Or you can select the “Customize” option in the sidebar then select “Chart style” and then mark the “3D” box.

  • After that, the 3D pie chart will be created.

how to create a 3D pie chart in google sheets


How to Customize a 3D Pie Chart?

After creating the 3D pie chart, you can customize it at your convenience. Here, we’ll discuss some of them.


1. Maximize 3D Pie Chart

You can maximize the size of your 3D pie chart for better visuality.

Steps:

  • At the “Chart editor” menu, select Customize then mark the Maximize option.

how to covert data into 3D pie chart in google sheets

  • After marking the Maximize box, the size of your 3D pie chart will be maximized.


2. Add Slice Label

You can add labels on slices in your 3D pie chart.

Steps:

  • Activate the “Chart editor” sidebar like previously. Then select Customize, go to the Pie chart drop-down then select Label from the Slice label
  • Soon after, you will get the labels on the slices like the image below.

how to add slice label in 3D pie chart in Google sheets

Read More: How to Label Pie Chart in Google Sheets (With Easy Steps)


3. Edit Slice Color

You can modify the slices in your 3D pie chart as well. Like, suppose you want to change the color of the slice of Lionel Messi from Blue to Yellow.

Steps:

  • Select Customize from the Chart editor, then go to the Pie slice drop-down, select Lionel Messi from the first Drop down, then select the color Yellow from the second Color Drop down option.

how to edit slice label color in 3D pie chart in Google sheets

Read More: How to Change Pie Chart Colors in Google Sheets


4. Change Chart Title

The title of the 3D pie chart you made can easily be changed. Suppose, you want to change the chart title from “Percentage” to “Ballon d’Or List 2011”.

Steps:

  • Activate the Chart editor by simply left-clicking twice on your 3D pie chart. Select Customize and then select Chart & axis titles Drop-down Simply type “Ballon d’Or List 2011” in the Title text box and the title will be changed.

how to change title of the 3D pie chart in google sheets

Read More: How to Change Title of Pie Chart on Google Sheets


5. Modify Legend

You can modify the legend in your 3D pie chart as well. Let’s assume, you want to-

  • Change the position of the legends to the bottom.
  • Change the legend font type to Georgia.
  • Change the legend font size to 14.
  • Change the legend format to Bold &
  • Change the text color of your legends to Dark Blue.

Steps:

  • Activate the Chart editor by left-clicking twice on your chart. Select Customize.
  • Then select the Legend Drop down Set the position of the legends to the Bottom from the “Position Dropdown option.
  • Change the legend font type to Georgia from the “Legend font Drop down
  • Set the font size to 14 from the “Legend font sizeDrop down
  • Set the legend format to Bold from the “Legend format” option.
  • Change the legend text color to Dark Blue from the “Text color” option and then you are all done.

how to modify legends in 3D pie chart in google sheets


Conclusion

As mentioned before, charts, graphs or diagrams are important for better understanding and for better visualization. These are the most time-saving processes for going through particular stuff as a whole. Creating 3D pie charts in Google Sheets is simpler than you thought, right? The following article elaborated on all the steps and important customization procedures to make a 3D pie chart in Google Sheets. Hope this may help with your task. Visit our website officewheel.com for more relevant articles. Thank you.


Related Articles

Adrey

Adrey

Hello! This is Raiyan Zaman Adrey, a fresh graduate in BSc in Civil Engineering from Bangladesh University of Engineering and Technology. From my high school I have been using Excel in which I was always interested and had fun and this led me to do more research on Excel and Google Sheets as both are kinda similar platform. I have always been enthusiastic, self-motivated, reliable and hard working person and for a long time, I am trying to improve myself more and more so that I can face any challenging situation and adapt myself to any environment.

We will be happy to hear your thoughts

Leave a reply

OfficeWheel
Logo