Home>Blogs>Charts and Visualization>Multilayered Doughnut Chart : Part-2
Multi Level Doughnut Chart
Charts and Visualization

Multilayered Doughnut Chart : Part-2

In this article you will learn how to create a beautiful Multilayered Doughnut Chart 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

 

Watch the video tutorial for multilayered doughnut chart-

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

Leave a Reply