In this article you will learn how to create 4 stylish doughnut charts in Excel. These doughnut charts are used to display the KPI metrics or progress of a project. Stylish Doughnuts can be used to in business dashboard or business presentation.
Stylish Doughnut Charts in Excel
Doughnut Chart-1:
- Let’s say we have a KPI metric on cell D1 and its performance value on cells E1. Here we will take a support column on cell F1.
- Put formula “=1-E1” on cell F1.
![KPI Metrics](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/StylishDoughnutChart/Stylish-Doughnuts-Chart-2.jpg)
- Select the range D1:F1.
- Go to Insert tab>>Charts>>Insert a doughnut chart.
![Insert doughnut Chart](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/StylishDoughnutChart/Stylish-Doughnuts-Chart-3.jpg)
- After inserting the chart successfully, select the legend and press delete.
![Delete Legend](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/StylishDoughnutChart/Stylish-Doughnuts-Chart-4.jpg)
- Now select the blue slice (double click on it)
- Go to the Format Data Points window and fill the Dark Teal color or any other dark color.
![Solid Fill](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/StylishDoughnutChart/Stylish-Doughnuts-Chart-5.jpg)
- Go to the Border in Format Data Points window.
- Select the Solid line.
- Select the Dark Teal color or the same color was take for Fill.
- Keep the Width as 15pt.
- Select Join Type as Round.
![Border Settings](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/StylishDoughnutChart/Stylish-Doughnuts-Chart-6.jpg)
- Now select the orange slice (double click on orange slice)
- Select the Solid fill available under Fill.
- Take the Dark Teal color or the same color which was taken for first slice.
- Keep Transparency as 75%.
- Select No line in Border.
![Select Slice settings](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/StylishDoughnutChart/Stylish-Doughnuts-Chart-7.jpg)
- Insert a Text box from the Insert Tab.
![Insert Text Box](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/StylishDoughnutChart/Stylish-Doughnuts-Chart-9.jpg)
- Drag the Text box in the middle of the chart.
- Select the Text box and go to formula bar and type “=$D$1“
- Text box will be linked with cell D1.
![Link text box with excel cell](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/StylishDoughnutChart/Stylish-Doughnuts-Chart-10.jpg)
Format the Text box-
- Choose text alignment Center.
- Choose font name “Impact“
- Choose font size 35.
- Choose font color Dark Teal.
- Choose chart title’s font color as Dark Teal.
![Text box setting](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/StylishDoughnutChart/Stylish-Doughnuts-Chart-11.jpg)
- Our first chart is ready and it will look like below given image.
Doughnut Chart-2:
- To create the 2nd doughnut chart make a copy of first doughnut chart.
![Copy the first chart](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/StylishDoughnutChart/Stylish-Doughnuts-Chart-13.jpg)
- Double click on the big slice (Teal slice) so that it will be selected.
- Go to the Format Data points window and fill the Orange color.
![Fill the orange color](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/StylishDoughnutChart/Stylish-Doughnuts-Chart-14.jpg)
- Go to the Border in Format Data Points window.
- Select the Solid line.
- Select the Orange color.
- Keep Transparency 35%.
- Keep the Width as 15pt.
- Select Join Type as Miter.
![Border Settings](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/StylishDoughnutChart/Stylish-Doughnuts-Chart-15.jpg)
- Now select the Transparent slice and fill the orange color.
- Make sure Transparency should be 75%.
![Transparent slide setting](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/StylishDoughnutChart/Stylish-Doughnuts-Chart-16.jpg)
- Change the font color of text box and chart title as orange.
Our 2nd doughnut chart is also ready.
Doughnut Chart-3:
To creating the 3rd doughnut chart make a copy of first doughnut chart.
![Make the copy of first doughnut chart](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/StylishDoughnutChart/Stylish-Doughnuts-Chart-17.jpg)
- Double click on the big slice (Teal slice) so that it will be selected.
- Go to the Format Data points window and fill the light blue color.
![Solid fill in first slice](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/StylishDoughnutChart/Stylish-Doughnuts-Chart-18.jpg)
- Go to the Border in Format Data Points window.
- Select the Solid line.
- Select the Light Blue color.
- Keep the Width as 15pt.
- Select Dash type as Round Dot (Second one).
![Border Settings](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/StylishDoughnutChart/Stylish-Doughnuts-Chart-19.jpg)
- Change the font color of text box and chart title as light blue.
Our third doughnut chart is also ready and will look like below image.
![3rd doughnut chart](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/StylishDoughnutChart/Stylish-Doughnuts-Chart-20.jpg)
Doughnut Chart-4:
To create the 4th doughnut chart make a copy of 3rd doughnut chart.
![Stylish Doughnut Charts in Excel](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/StylishDoughnutChart/Stylish-Doughnuts-Chart-21.jpg)
- Double click on the big slice (light blue slice) so that it will be selected.
- Go to the Format Data points window and fill the Orange, Accent 2 color.
![First slice setting](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/StylishDoughnutChart/Stylish-Doughnuts-Chart-22.jpg)
- Go to the Border in Format Data Points window.
- Select the Solid line.
- Select the Orange, Accent 2 color.
- Keep the Width as 15pt.
- Select Cap type as Round.
![Border Setting](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/StylishDoughnutChart/Stylish-Doughnuts-Chart-23.jpg)
- Now select the Transparent slice and fill the Orange, Accent 2 color.
- Make sure Transparency should be 75%.
![Transparent Slice Setting](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/StylishDoughnutChart/Stylish-Doughnuts-Chart-24.jpg)
- Change the font color of text box and chart title as Orange, Accent 2 color.
Our 4th doughnut chart is also ready and will look like below image.
![4th Doughnut Chart](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ChartAndVisualization/StylishDoughnutChart/Stylish-Doughnuts-Chart-25.jpg)
Visit our YouTube channel to learn step-by-step video tutorials