3D Doughnut Chart
Charts and Visualization

3D Doughnut Chart for KPI Metrics

In this article you will learn how to create beautiful 3D Doughnut Chart for KPI metrics like (Service Level, Quality Score, Sales Conversion etc.). 3D Doughnut chart is not default available in Excel like a 3D Pie Chart is available in Excel. We will use some tricks to create this chart in Excel.

This stunning chart can be used in business dashboards or business Presentation.

3D Doughnut Chart
3D Doughnut Chart

Below are the steps to create this chart in Excel-

Let’s say we have to create the 3D doughnut KPI chart to Service Level metric.

  • We are putting our Service level value on range “E1”
  • Put formula “=1-E1” on range “F1”
Formula
Put Formula
  • Go to the Insert>>Shape>>Select the Doughnut available under Basic Shapes
Doughnut Shape in Basic Shapes
Doughnut Shape in Basic Shapes
  • Drag the shape on the worksheet.
Doughnut Shape
Doughnut Shape
  • Pick the yellow handle of the shape and change the width of Doughnut.
Decrease the doughnut width
Decrease the doughnut width
  • Right click on the Doughnut and click on Format Shape.
Format Shape
Format Shape
  • In the Format Shape window select the Shape Effects.
  • Go to 3-D Rotation option and select the preset.
Format Shape window
Format Shape window
  • Select the Isometric Top Up preset in the Parallel.
Select Preset
Select Preset
  • Now change the X Rotation = 340°,  Y Rotation = 320°, Z Rotation = 30°
Change the Rotation
Change the Rotation
  • Go to the 3-D Format option in Effects.
  • Select the Top bevel.

 

3-D Format Option
3-D Format Option
  • Select the Cool Slant Bevel from the list.
Bevel List
Bevel List
  • Change the Depth as 6pt in 3-D Format.
Change the Depth
Change the Depth
  • Now go to Shadow under Effects option and select Preset.
Shadow option
Shadow option
  • Choose the Perspective Diagonal Upper Left shadow under Perspective.
Shadow Presets
Shadow Presets
  • Our Doughnut shape is ready to use. It will look like below image.
Doughnut Shape after applying formatting
Doughnut Shape after applying formatting
  • Now remove the gridlines from the worksheet.
  • Click anywhere on the worksheet.
  • Go to View tab and uncheck the Gridlines checkbox.
Remove Gridlines from worksheet
Remove Gridlines from worksheet
  • Select the range “E1:F1”
  • Go to Insert>>Charts>>Insert 2D Pie Chart.Insert Pie Chart

Insert Pie Chart

  • Remove all the elements from the Chart like – Title and Legend
  • Keep the chart over the Doughnut Shape.
Remove Chart Elements
Remove Chart Elements
  • Now Select the Chart Area and go the format Tab.
  • Take the Shape as No Fill.
  • Take the Outline as No Outline.
  • Double click on blue Slice in the Pie chart. It will be selected.
  • Right click and click on Format Data Series.
  • Go to Fill and Line option and Fill as No fill
  • Border as No Line.
Fill as No fill
Fill as No fill
  • After doing the above given formatting our chart will look like below image.
3D Doughnut Chart
3D Doughnut Chart
  • Double click on the Orange Slice of Pie chart. It will be selected.
  • Fill the Color as White color.
  • Give the Transparency as 15%.
Color and Transparency
Color and Transparency
  • After doing the above given settings our chart will look like below image.
3D - Doughnut Chart
3D – Doughnut Chart
  • Now we will add the Data Labels.
  • Go to the Insert tab and select the Text Box.
Text Box Option
Text Box Option
  • Drag the Text Box on the worksheet.
  • Select the Text Box and go to Formula bar.
  • Press “=” in formula bar and click on range “E1”
  • Text Box value will be linked with the SL value.
Link the Text Box with cell
Link the Text Box with cell

 

  • Select the Text box and go to Home tab.
  • Change the Vertical and Horizontal alignment as Center.
  • Take the Font Name as “Impact
  • Take the Font Size as “35
  • Put the Text box in the center of Doughnut.

Our 3D Doughnut Chart is ready and It will look like below image.

3D Doughnut Chart
3D Doughnut Chart

Click here to download the Excel file of 3D Doughnut Chart

Video Tutorial for 3D Doughnut Chart for KPI Metrics 

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com

Leave a Reply

Your email address will not be published. Required fields are marked *