How to Create a 3D Pie Chart in Excel (with Easy Steps)

The 3D pie chart consists of a circle that is divided into segments, each representing a proportion of the share of each value in a dataset. The chart is very helpful in understanding the share of each segment in a dataset. It adds aesthetics to the plain pie chart by making it more lively. In this article, we will see how to create a 3D pie chart in Excel.


Download Practice Workbook

You can download the Excel workbook from here.


Step-by-Step Procedures to Create a 3D Pie Chart in Excel

In order to create a 3D pie chart in Excel, we will need a dataset like the below image. The dataset contains Days of the Week and Sales Per Day. The 3D pie chart is most useful when it is created from two variables. Now we will create a 3D pie chart in Excel from this dataset to represent the share of each day’s sale in a single chart.

Step-by-Step Procedures to Create a 3D Pie Chart in Excel


Step 1: Select Dataset

  • First, select the entire dataset like the image below.

Select Dataset


Step 2: Insert 3D Pie Chart

  • Next, click on the Insert tab >> Insert Pie or Doughnut Chart drop-down >> 3-D Pie option like the image below.

Insert 3D Pie Chart

  • As a result, it will create a 3D pie chart like the below one.


Step 3: Change Chart Title and Deselect Legend

  • After that, click on the Chart Title and change it as you want like the image below.

Change Chart Title and Deselect Legend

  • Next, click on the Chart Elements option.

Change Chart Title and Deselect Legend

  • Then, deselect the Legend option from the Chart Elements.


Step 4: Add and Format Data Labels of 3D Pie Chart

  • Subsequently, select the Data Labels from the Chart Elements like the image below.
  • As a result, it will add the Data Labels to your 3D pie chart.

Add and Format Data Labels of 3D Pie Chart

  • Now, in order to format the Data Labels, click on any Data Label and right-click on your mouse.
  • Hence, a pop-up window will appear.
  • After that, click on the Format Data Labels option from the pop-up window.

Add and Format Data Labels

  • Then, a new pop-up window Format Data Labels will appear at the rightmost position of the screen like the image below.

Add and Format Data Labels

  • Now, select the Category Name option from the Label Contains and the Outside End option from the Label Position.


Final Output

  • Finally, your 3D Pie Chart is ready and you will see an output like the image below.

Final Output


Things to Remember

  • If you want to represent a proportion of the share of each value in a dataset and show a comparison among them, the 3D pie chart will be the best option for you.
  • The 3D pie chart is really useful for two variables. When the number of variables increases, the chart becomes visually complex.
  • After creating the 3D pie chart, you can modify the chart and format the data labels in your own way.

Conclusion

Hence, follow the above-described steps. Thus, you can easily learn how to create a 3D pie chart in Excel. Hope this will be helpful. Follow the ExcelDemy website for more articles like this. Don’t forget to drop your comments, suggestions, or queries in the comment section below.

Md. Asaduzzaman

Md. Asaduzzaman

Hello! I am Md. Asaduzzaman. Currently, I am working as an Excel and VBA Content Developer and I will be posting my articles related to this here. I graduated from Bangladesh University of Science and Technology(BUET) in 2022. I completed my BSc in Naval Architecture and Marine Engineering. I like to solve real-life problems in Microsoft Excel and share the solutions through articles. I post here regularly. Hope you find the articles helpful.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo