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

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.

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.

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.

The full-doughnut chart will be visible.

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.

Press ENTER. The doughnut chart will be rotated.

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.

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

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.

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

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

• Excel Doughnut Chart with Multiple Rings
• How to Make 3D Doughnut Chart in Excel

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