EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Charts Excel Doughnut chart
Secondary Sidebar
Excel Functions
  • Excel Charts
    • Excel Data Visualization
    • Dashboard in Excel
    • Bullet Chart in Excel
    • Excel Animation Chart
    • Plots in Excel  
    • Interactive Chart in Excel
    • Surface Charts in Excel
    • Excel Calendar Template
    • Thermometer Chart in Excel
    • Box Plot in Excel
    • S CURVE in Excel
    • Venn Diagram in Excel
    • Project Management with Gantt Chart
    • Change Chart Style in Excel
    • 3D Scatter Plot in Excel
    • Box and Whisker Plot in Excel
    • Radar Chart in Excel
    • Control Charts in Excel
    • Dot Plots in Excel
    • Marimekko Chart Excel
    • Combo Chart in Excel
    • Contour Plots in Excel
    • Candlestick Chart in Excel
    • Map Chart in Excel
    • Pie Chart Examples
    • Excel Stacked Bar Chart
    • Excel Flowchart
    • Excel Types of Graphs
    • Excel Normal Distribution Graph
    • Excel Bell Curve
    • Legends in Excel Chart
    • Excel Chart Templates
    • Excel Organization Chart
    • Excel Doughnut chart
    • Excel 3D Plot
    • Excel Scatter Chart
    • Excel Line Chart
    • Excel Combination Charts
    • Excel Gauge Chart
    • Excel Pivot Chart
    • Excel Clustered Column Chart
    • Excel Dynamic Chart
    • Excel Stacked Column Chart
    • Excel Bubble Chart
    • Histogram Chart Excel
    • Excel Gantt Chart
    • Excel Stacked Area Chart
    • Excel Waterfall Chart
    • Excel Area Chart
    • Excel Clustered Bar Chart
    • Excel Column Chart
    • Excel Pie Chart
    • Comparison Chart in Excel
    • Pareto Analysis in Excel
    • Add a Secondary Axis in Excel
    • Grouped Bar Chart
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED COURSE
  • Excel Data Analysis Course
  • Excel for Marketing Course

Excel Doughnut chart

By Madhuri ThakurMadhuri Thakur

Doughnut Chart in Excel

Excel Doughnut chart (Table of Contents)

  • Doughnut Chart in Excel
  • How to Create Doughnut Charts in Excel?

Doughnut Chart in Excel

Doughnut chart is a built-in feature in excel. It is used to represent the proportion of data where the total should be 100%. It looks a little similar to a pie chart with a hole.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,325 ratings)

How to Create Doughnut Charts in Excel?

Now we will see How to Create Doughnut Charts in Excel. We will see How to create different types of Doughnut Charts in Excel, like Doughnut Chart with Single data series, Double Doughnut Chart and Doughnut Chart with Multiple data series and how to modify them with some examples.

You can download this Doughnut Chart Excel Template here – Doughnut Chart Excel Template

Doughnut Chart in Excel – Example #1

Following is an example of a single doughnut in excel:

Single Doughnut Charts in Excel

Consider a project which has three stages like completed, work InProgress, Incomplete. We will create a doughnut chart to represent the project status percentage-wise.

Doughnut Chart in Excel Example 1-1

Consider the example of the above status of the project and will create a doughnut chart for that. Select the data table and click on the Insert menu. Under charts, select the Doughnut chart.

Doughnut Chart in Excel Example 1-2

The chart will look like below.

Doughnut Chart in Excel Example 1-3

Now click on the + symbol that appears top right of the chart, which will open the popup. Untick the Chart Title and Legend to remove the text in the chart.

Doughnut Chart in Excel Example 1-4

Once you do that, the chart will look like below.

Doughnut Chart in Excel Example 1-5

Now we will format the chart. Select the chart and right-click a pop-up menu that will appear from that, select the Format Data Series.

Doughnut Chart in Excel Example 1-6

When clicking on the Format Data series, a format menu appears on the right side.

Doughnut Chart in Excel Example 1-7

The “Format Data Series” menu reduces the Doughnut Hole Size. Currently, it is 75% now reduce to 50%.

Doughnut Chart in Excel Example 1-8

Now to input, the percentage text selects the Doughnut Then click on Shapes under Illustrations option from Insert menu and select Rectangle box.

Doughnut Chart in Excel Example 1-9

Now click on the inserted rectangle shape and select the Text box, shown in the picture below.

Doughnut Chart in Excel Example 1-10

Now give the formula to represent the status of the project. For that input = (equal sign) in the text box and select the cell which shows the value of completed status that is B2.

Doughnut Chart in Excel Example 1-11

Now we should format that text. Right-click on the text and select the format. Select the Fill and select No Fill, then the blue color will disappear.

Doughnut Chart in Excel Example 1-12

Now apply a format to the text as per your doughnut color for that particular field. Now it is showing in Orange color; hence we will set the text color also in “Orange”.

Select the text and right-click from the pop-up, select the formatting data series, and a menu will appear on the right side. From the right-side menu, select “Text options” and change the color to “Orange”.

Doughnut Chart in Excel Example 1-13

Similarly, input the text for incomplete and work inprogess.

Doughnut Chart in Excel Example 1-14

Now change the percentages and see how the chart changes.

Doughnut Chart in Excel Example 1-15

We can observe the changes in the chart and text if we input the formula in “Incomplete” like 100%-completed-Work InProgress. So that Incomplete will pick automatically.

Doughnut Chart in Excel – Example #2

Following is an example of a doughnut chart in excel:

Double Doughnut Chart in Excel

With the help of a double doughnut chart, we can show the two matrices in our chart. Let’s take an example of sales of a company.

Here we are considering two years sales as shown below for the products X, Y, and Z.

Doughnut Chart in Excel Example 2-1

Now we will create a doughnut chart as similar to the previous single doughnut chart. Select the data alone without headers, as shown in the below image. Click on the Insert menu. Go to charts select the PIE chart drop-down menu. From Dropdown, select the doughnut symbol.

Doughnut Chart in Excel Example 2-2

Then the below chart will appear on the screen with two doughnut rings.

Doughnut Chart in Excel Example 2-3

To reduce the doughnuts hole size, select the doughnuts and right-click and then select Format data series. Now we can find the option Doughnut Hole Size at the bottom where you drag the percentage to reduce.

Doughnut Chart in Excel Example 2-4

If we want to change the angle of the doughnut, change the settings of “Angle of the first slice”. We can observe the difference between 0 degrees and 90 degrees.

Doughnut Chart in Excel Example 2-5

If we want to increase the gap between the rings, adjust the Doughnut Explosion. Observe the below image for reference.

Example 2-6

If we want to add the shadow, select the middle option, which is highlighted. select the required Shadow option.

Example 2-7

After applying the shadow, we can adjust the shadow related options like Color, Transparency, size etc.

If we want to apply the color shadow, use the menu Glow at the bottom of the “shadow” menu. As per the selected color, the shadow will appear.

Example 2-8

If we want to increase the softness of the edges, change the settings of softness by selecting Soft Edges at the bottom of the Glow menu.

 Example 2-9

If we want a different color, select the particular ring we want to change the color. To identify which ring you selected to observe the data (Data will highlight as per your ring selection). Observe the below image; only the year 2018 is highlighted.

Select the particular part of the selected ring and change the color as per your requirement. Please find the color box which is highlighted.

Example 2-10

If we want to add the border to the ring, select the ring or part of the ring in which you want to add a border. Go to option Fill and line. Select the solid line and then change the required color for the border.

 Example 2-11

After applying the border to the selected rings, the results will look as shown below.

 Example 2-12

We can adjust the Width, Transparency, Dash type etc., as per your requirements.

If we want to fill a single color for the entire ring, then deselect the option which is highlighted.

Example 2-13

If we want the data figures on the ring then, select the ring and right-click select the option Add Data Labels.

Example 2-14

Then the data labels will appear on the ring, as shown below.

Example 2-15

Doughnut Chart in Excel – Example #3

Following is an example of multiple doughnuts in excel:

Multiple Doughnut Charts in Excel

Multiple doughnut charts are also created in a similar way; the only thing required to create multiple doughnuts is multiple matrices. For example, in the double doughnut, we have two years of data; if we have 3 or 4 years of data, then we can create multiple doughnut charts.

Things to Remember

  • Doughnut charts are similar to Pie charts which has a hole in the center.
  • Doughnut charts help to create a visualization with single matrices, double and multiple matrices.
  • It mostly helps to create a chart for a total of 100 percent matrices.
  • It is possible to create single doughnut, double doughnut, and multiple doughnut charts.

Recommended Articles

This has been a guide to Doughnut Chart in Excel. Here we discussed How to Create Doughnut Chart in Excel and Types of Doughnut Charts in Excel, along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Pie Chart in Excel
  2. Excel Data Bars
  3. Excel Line Chart
  4. Marimekko Chart Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Data Analysis Training (17 Courses, 8+ Projects)4.9
Excel for Marketing Training (8 Courses, 13+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Doughnut Chart Excel Template

EDUCBA

Download Doughnut Chart Excel Template

EDUCBA

डाउनलोड Doughnut Chart Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more