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 1: Select Dataset
- First, select the entire dataset like the image below.
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.
- As a result, it will create a 3D pie chart like the below one.
Similar Readings
- How to Change Pie Chart Colors in Excel (4 Easy Ways)
- How to Show Pie Chart Data Labels in Percentage in Excel
- [Fixed] Excel Pie Chart Leader Lines Not Showing
- How to Make a Pie Chart in Excel without Numbers (2 Effective Ways)
- How to Make Multiple Pie Charts from One Table (3 Easy Ways)
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.
- Next, click on the Chart Elements option.
- Then, deselect the Legend option from the Chart Elements.
Read More: How to Make Two Pie Charts with One Legend in Excel
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.
- 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.
- Then, a new pop-up window Format Data Labels will appear at the rightmost position of the screen like the image below.
- Now, select the Category Name option from the Label Contains and the Outside End option from the Label Position.
Read More: Add Labels with Lines in an Excel Pie Chart (with Easy Steps)
Final Output
- Finally, your 3D Pie Chart is ready and you will see an output like the image below.
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.
Related Articles
- How to Make a Pie Chart with Multiple Data in Excel (2 Ways)
- How to Edit Legend of a Pie Chart in Excel (3 Easy Methods)
- Excel Pie Chart Labels on Slices: Add, Show & Modify Factors
- How to Make a Pie Chart in Excel with Words (with Easy Steps)
- How to Make Pie Chart in Excel with Subcategories (2 Quick Methods)
- [Solved]: Excel Pie Chart Not Grouping Data (with Easy Fix)