Home>Blogs>Charts and Visualization>3D Disk Pie Chart in Excel
Disk Pie Chart
Charts and Visualization

3D Disk Pie Chart in Excel

In today’s world, data visualization has become an essential part of business presentations and reporting. It helps to communicate complex information in a simple and visually appealing way. One of the popular visualization techniques is the pie chart. It displays data in slices that make up a whole. A 3D disk Pie Chart takes it one step further by adding a 3D effect which makes it even more visually appealing.

What is a 3D Disk Pie Chart in Excel?

A 3D disk pie chart is a type of Pie chart which displays data as slices of a disk. The chart is similar to a traditional pie chart. It has a 3D effect which makes it more visually appealing. You can use this chart to represent your categorized data.

Steps to create a 3D Disk Pie Chart in Excel

Input your data into Excel. For example, let’s consider day-wise sales. Follow the below steps-

Day wise sales data
Day wise sales data

 

  • Select the Data and insert a 3D Pie Chart
insert a 3D Pie Chart
insert a 3D Pie Chart

 

  • Right click on the chart and click on “Format Data Series”.
Format Data Series
Format Data Series

 

  • Go to the Effects in Format Data Series.
Effects in Format Data Series
Effects in Format Data Series

 

  • In the Effects, open the 3-D format feature.
3-D format
3-D format

 

  • Select the Top and Bottom Bevel as “Round” or “Circle”
Top and Bottom Bevel
Top and Bottom Bevel

 

  • Put the Width and Height as 100 pt for Top and Bottom bevel.
Width and Height as 100 pt
Width and Height as 100 pt

 

  • Now the chart will look like 3D disk chart. Remove the Legends and Add Data Labels form the Chart Elements.
Chart Elements
Chart Elements

 

  • Right click on the Data Labels and click on the Format Data Labels.
Format Data Labels
Format Data Labels

 

  • In the Format Data Labels, Select the Category Name in the Label Contains

 

Category Name
Category Name

 

  • Select the Label Position as Outside End.
Label Position as Outside End
Label Position as Outside End

Now our chart is ready. You do more adjustments if you need.

Disk Pie Chart

 Click here to download this Excel File:

Watch the step-by-step video tutorial:

PK
Meet PK, the founder of PK-AnExcelExpert.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your Excel skills to the next level!
https://www.pk-anexcelexpert.com