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](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-2.jpg)
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](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-3.jpg)
- Select the range “A2:C4”
- Go to Insert tab>>Charts>>Insert Doughnut Chart.
![Insert Doughnut Chart](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-4.jpg)
- Right click on the doughnut and click on Select Data.
![Select Data option](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-5.jpg)
- Select Data Source window will be opened.
- Click on Switch Row/Column.
- Click on OK button.
![Select Data Source window](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-6.jpg)
- Right click on doughnut again and click on Format Data Series.
![Format Data Series option](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-7.jpg)
- 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](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-8.jpg)
- 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](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-9.jpg)
- 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](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-10.jpg)
- 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](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-11.jpg)
- 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](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-12.jpg)
- Now go to Insert tab>>Shapes>>Insert a Rectangle.
![Insert Rectangle](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-13.jpg)
- Drag the rectangle with the charts as given in below image and fill the dark blue color.
![Drag and fill rectangle](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-14.jpg)
- Insert 2 more rectangles and fill green and gold colors
![fill green and gold colors for other rectangle](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-15.jpg)
- 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](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-16.jpg)
- Go to Insert tab>>Insert a text box.
![Insert text box](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-17.jpg)
- 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](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-18.jpg)
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](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-19.jpg)
- Go to the insert tab and insert an Oval.
![Insert Oval](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-20.jpg)
- Drag a small oval.
- Fill the Gradient fill and choose preset gradient as given in below image.
![Create Oval](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-22.jpg)
- Create 2 more oval and fill the different preset gradients for gold color and green color.
![Create 2 more oval](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-23.jpg)
- Insert one more oval and fill the gradient color as given in below image.
![Middle Circle](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-24.jpg)
- Take the Shadow as Offset Center.
![Shadow as Offset Center](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-25.jpg)
- Our multilayered doughnut chart is ready and will look like below image.
![Multilayered Doughnut chart for metrics](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/Multi_Layered_Doughnut_Part1/Multi-Layered-Doughnut-Chart-Part-1-26.jpg)
Visit our YouTube channel to learn step-by-step video tutorials