Multi Level Doughnut Chart
Charts and Visualization

Multilayered Doughnut Chart : Part-2

In this article you will learn how to create a beautiful doughnut chart with multiple layers to display the team level performance. This chart can be used in business dashboard or presentation. We can create this chart to display 5 or 6 teams performance at a time.

Below are the steps to create a multilayered doughnut chart for team performance-

  • Below is the data set for 5 teams and their sales. we will create the multilayered doughnut chart for this data set.
Team wise sales
Team wise sales
  • We will take a support on column C.
  • Put the formula “=MAX(B2:B6)*1.25” on cell C1
  • Put the formula “=$C$1-B2” on cell C2
  • Fill down the formula on  “C2:C6”
Support Column
Support Column
  • Select the range “A2:C6
  • Go to Insert tab>>Charts>>Insert a Doughnut Chart.
Insert a doughnut chart
Insert a 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 button.
Select Data Source window
Select Data Source window

 

  • Now right click on the doughnut and click on Format Data Series.
  • In Format Data Series window take the Doughnut Hole Size 30%.
Format Data Series Window
Format Data Series Window

 

  • Select the Orange slice(double click to select) of first doughnut and fill it as No fill.
  • Repeat the same activity for other slices.
Fill Orange slice as No fill
Fill Orange slice as No fill

 

  • Select the blue slice (double click to select) of first doughnut and fill it as dark blue.
Fill dark blue color in blue slice of first doughnut
Fill dark blue color in blue slice of first doughnut
  • Fill the color in rest blue slices as given in below image.

 

  • Create a support column for Data Label on column D.
  • Put the formula =A2&”(“&B2&”)” on cell D2.
  • Fill down the formula for “D2:D6
Data Label Column
Data Label Column
  • Go to the Insert tab and insert a Text box.
Text box
Text box
  • Select the text box and go to formula bar and type “=$D$2
  • Text box will be linked with cell D2.

 

link the text box with excel cell
link the text box with excel cell

Format the Text box like-

  • Text alignment right.
  • Shape fill as No fill.
  • Shape outline as No outline.
  • Make font bold.

Keep this text box with the small doughnut. Create the 4 more text boxes and link with cells D3, D4, D5 and D6. Keep these text boxes with the doughnuts as given in below image.

 

 

Our Multilayered Doughnut Chart is ready and will look like below given image.

 

Multilayered Doughnut Chart in Excel
Multilayered Doughnut Chart in Excel

 

Click here to download this excel file.

Watch the video tutorial for multilayered doughnut chart-

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 12 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