Multilayered Doughnut Chart-Part1
Charts and Visualization

Multilayered Doughnut Chart : Part-1

In this article you will learn how to create a beautiful multilayered Doughnut Chart for KPI metrics. In this chart we can display 3 or 4 KPI metrics at a time. This chart can be used in business presentations or dashboards.

Below is the data set for which we will create multilayered Doughnut Chart.

Metrics data set
Metrics data set

Below are the steps to create the multilayered Doughnut Chart.

  • Put the formula “=1.1-B2” on column C2.
  • Fill down the formula till C4.
Support Column
Support Column
  • Select the range “A2:C4
  • Go to Insert tab>>Charts>>Insert Doughnut Chart.
Insert Doughnut Chart
Insert Doughnut Chart
  • Right click on the doughnut and click on Select Data.
Select Data option
Select Data option
  • Select Data Source window will be opened.
  • Click on Switch Row/Column.
  • Click on OK button.
Select Data Source window
Select Data Source window
  • Right click on doughnut again and click on Format Data Series.
Format Data Series option
Format Data Series option
  • Format Data Series window will be displayed.
  • Put 180° in Angle of the first slice.
  • Put the “Doughnut Hole Size” 40%.
Format Data Series window
Format Data Series window
  • Select the first doughnut layer
  • Go to the Format Tab>>Shape Outline>> Click on No outline.
  • Repeat this activity for all the three doughnut layers.
Remove outlines
Remove outlines

 

  • Select the Orange slice of first doughnut layer.
  • Go to the Fill and Line option in Format Data points.
  • Choose No fill available under fill.
  • Repeat this activity for all the three doughnut layers.
No fill or orange slices
No fill or orange slices

 

  • Select the Blue slice of first doughnut layer.
  • Go to the Fill and Line option in Format Data points.
  • Choose Gradient Fill available under fill.
  • Select the Type as Linear.
  • Put Angle 270°.
  • Keep 2 stops in Gradient Stops.
  • Select dark gold color for first stop and light gold color for second stop.

 

Fill Gradient fill
Fill Gradient fill
  • Repeat the above activity for rest doughnut layers.
  • Keep the green color for middle layer and blue color for small layer.
Gradient fill for other slices
Gradient fill for other slices
  • Now go to Insert tab>>Shapes>>Insert a Rectangle.
Insert Rectangle
Insert Rectangle

 

  • Drag the rectangle with the charts as given in below image and fill the dark blue color.
Drag and fill rectangle
Drag and fill rectangle

 

  • Insert 2 more rectangles and fill green and gold colors
fill green and gold colors for other rectangle
fill green and gold colors for other rectangle

 

  • Create a support column for Data label.
  • Put formula “=A2&TEXT(B2,” (0%)”)” on cell D2.
  • Fill down this formula till D4.
Data Label column
Data Label column
  • Go to Insert tab>>Insert a text box.
Insert text box
Insert text box

 

  • Drag the Text box on the worksheet.
  • Select the text box and go the formula bar and type “=$D$2”
Connect Text box with Excel Cell
Connect Text box with Excel Cell

 

Format the text box like:

  • Take right text alignment
  • Shape fill as No fill.
  • Shape outline as No outline.
  • Font color as White.
  • Keep the text box on blue rectangle.
  • Insert two more text boxes and connect it with D3 and D4.
Format the text box
Format the text box
  • Go to the insert tab and insert an Oval.
Insert Oval
Insert Oval
  • Drag a small oval.
  • Fill the Gradient fill and choose preset gradient as given in below image.
Create Oval
Create Oval

 

  • Create 2 more oval and fill the different preset gradients for gold color and green color.
Create 2 more oval
Create 2 more oval
  • Insert one more oval and fill the gradient color as given in below image.
Middle Circle
Middle Circle
  • Take the Shadow as Offset Center.
Shadow as Offset Center
Shadow as Offset Center
  • Our multilayered doughnut chart is ready and will look like below image.
Multilayered Doughnut chart for metrics
Multilayered Doughnut chart for metrics

 

 

Click here to download this Excel File.

Watch the video tutorial for Multilayered Doughnut Chart Part-1

 

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 *