How to Create Half Doughnut Chart in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

A half-doughnut chart is a type of chart that displays data in a half-circle shape with a hole in the center. It is a useful tool for presenting data in a visually appealing way and making it easier to understand. If you are looking to create a half-doughnut chart in Excel, then this article is for you.

Overview of Half Doughnut Chart in Excel

In this article, we will provide a step-by-step guide on how to create a half-doughnut chart in Excel, highlighting the advantages and use cases of this chart type. We will also explore the difference between a pie chart and a doughnut chart and explain why a half-doughnut chart may be a better choice than a full-doughnut chart. By following the 5 simple steps outlined in this article, you can create a professional-looking half-doughnut chart that effectively communicates your data and insights.


Half Doughnut Chart in Excel: Advantage and Uses

A half-doughnut chart, also known as a half-donut chart or a semicircle donut chart, is a circular chart that displays data in a half-circle shape with a hole in the center. It is a variation of the standard doughnut chart, which is a type of pie chart with a hole in the center.

Advantage:

  • The main advantage of a half-doughnut chart is that it allows you to display more data in a smaller space.
  • It is particularly useful when you want to show a single data series as a percentage of a whole, and you want to compare multiple data points within that series.

Use of Half Doughnut Chart:

  • One common use case for a half-doughnut chart is in financial reporting, where it is often used to show the percentage breakdown of expenses or revenue by category.
  • Another use case is in marketing, where it can be used to show the distribution of sales by product or by region.

How to Create Half Doughnut Chart in Excel: with Easy Steps

Now, Let us look into the steps of creating a Half-Doughnut Chart with detailed instructions.

Step 1: Add an Extra Data Series Named “Total”

To begin with, we need to insert a new row inside the table to calculate the Total Revenue. Type the following formula inside cell C10 and Press ENTER.

=SUM(C5:C9)

Adding an Extra Row and Calculating Total by Using SUM() Function

The sum of the revenues will be visible inside cell C10.

Read More: How to Make a Doughnut Chart in Excel


Step 2: Insert a Simple Full Doughnut Chart

After that, select the data from the table and insert a Doughnut Chart following the procedure mentioned inside the image.

Inserting Full-Doughnut Chart

The full-doughnut chart will be visible.

Full-Doughnut Chart After Inserting it.


Step 3: Rotate the Doughnut Chart

Now to rotate the doughnut chart, double-click on the marked area inside the image. Under the Format Data Series select Series Options and set the Angle of first slice to 270 Degrees.

Rotating Doughnut Chart

Press ENTER. The doughnut chart will be rotated.

Rotated View of Doughnut Chart


Step 4: Hide the Extra Series Named “Total”

To turn this full-doughnut chart into a half-doughnut chart, we need to hide the portion designated as “Total”. First, select the undesired part of the chart and double-click. Then, under Format Data Point select Fill and from the dropdown list, select No Fill.

Hiding Extra Series

Your full-doughnut chart has now become a half-one.

Full-Doughnut Chart Turns into Half-Doughnut Chart


Step 5: Delete Extra Chart Legend and Fix Chart Title

Finally, as a finishing touch, we need to delete the extra legend inside the chart and give the chart an appropriate title. To do that, select “Total” from the legend list and press DELETE from your keyboard. Then, click on “Chart Title” and rename the title.

Fixing Chart Title and Deleting Unnecessary Legend

Your half-doughnut chart is now complete. You can adjust the legend and title fonts suitably to meet your purpose.

Final View of Half-Doughnut Chart


Difference Between Excel Pie Chart and Doughnut Chart

Pie charts and doughnut charts are both used to represent data in a circular format, but there are some key differences between the two:

  • Appearance: Pie charts have a solid circle in the center, while doughnut charts have a hole in the center, giving them the appearance of a doughnut.
  • Usage: Pie charts are best used to show the relative size of each category in relation to the whole data set. Doughnut charts are similar but are better used when you want to show the breakdown of a single category into subcategories.
  • Data Display: In a pie chart, data is displayed in the form of slices, where each slice represents a category and its size corresponds to its proportion of the whole. In a doughnut chart, data is displayed in the form of concentric rings, where the outer ring represents the main category and the inner rings represent its subcategories.
  • Information: Pie charts are simple and easy to read, but they can become cluttered and difficult to understand if there are too many categories. Doughnut charts can be more informative, as they can show the relationship between a main category and its subcategories, but they can also become difficult to read if there are too many subcategories.

Why Should You Choose Half Doughnut Chart Over Full Doughnut Chart?

The half-doughnut chart is advantageous over the full-doughnut chart in certain situations because it can display data in a more compact and visually appealing way.

Firstly, the half doughnut chart occupies less space than the full doughnut chart because it only uses half of the circle, which makes it more suitable for smaller screens or print materials where space is limited.

Secondly, the half-doughnut chart has a more symmetrical shape, which can make it easier to read and interpret the data accurately. In contrast, the full doughnut chart can sometimes look unbalanced, especially if the inner circle is small.

Lastly, the half-doughnut chart can be used to emphasize a specific data point, since the other half of the chart is blank. For example, if you want to draw attention to a particular category or data point, you can use a half-doughnut chart to highlight it.

However, it is important to note that the choice between a half-doughnut chart and a full-doughnut chart depends on the specific data being presented and the context of the chart. In some cases, a full doughnut chart may be more appropriate, especially if there are multiple data series that need to be compared within the same chart.


Things to Remember

  • A half-doughnut chart is best suited for displaying a single data series as a proportion of a whole, so it is important to choose data that can be presented in this way. If you have multiple data series, it may be better to use a different type of chart, such as a stacked bar chart or a multi-series line chart.
  • You should label each segment of the chart with the corresponding data point and the percentage it represents. You may also want to provide additional information or a legend to help readers interpret the chart accurately.

Download Practice Book

You can download our practice workbook from here for free!


Conclusion

In conclusion, we have learned how to create a half-doughnut chart in Excel, a useful tool for displaying data in a visually appealing and easy-to-read way. By following the steps outlined in this article, you can create a half-doughnut chart that effectively communicates your data and insights. If you have any questions or comments, please feel free to leave them in the comment section below.


Related Articles


<< Go Back to Excel Doughnut Chart | Excel Charts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Nafis Soumik
Md. Nafis Soumik

Md. Nafis Soumik graduated from Bangladesh University of Engineering & Technology, Dhaka, with a BSc.Engg in Naval Architecture & Marine Engineering. In January 2023, he joined Softeko as an Excel and VBA content developer, contributing 50+ articles on topics including Data Analysis, Visualization, Pivot Tables, Power Query, and VBA. Soumik participated in 2 specialized training programs on VBA and Chart & Dashboard designing in Excel. During leisure, he enjoys music, travel, and science documentaries, reflecting a diverse range... Read Full Bio

2 Comments
  1. Hi,

    I need to show the percentage on the series data labels, but in the solution you suggested the pecentages are showing in half also.
    Is there any workaround solution to show the correct percentages on the shown series?

    Thanks.

    • Reply Nafis Soumik
      Md. Nafis Soumik Oct 3, 2023 at 9:22 AM

      Hi Mahmoud,
      You can create a half doughnut chart to show the correct percentages with data labels by following the steps mentioned in this article. Only exception is you will need a different data table with the yearly revenues converted into percentages of the total.
      You can do this by applying the following formula inside any cell: =C5/$C$10. Use fill handle to populate the dataset and keep the percentage column into percentage format. Now follow the exact steps described in this article. Upon finishing check the Data Labels option from Chart Element. Your half doughnut chart with percentage Data labels is now ready.
      Half Doughnut Chart Showing Actual Percentages
      I hope it solves your problem.

      Regards,
      ExcelDemy.

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo