How to Make a Donut Chart in Excel

Published December 09, 2024 by Tech

Warm greetings to Arisha friends! This article will discuss how to create a donut chart in Excel easily and quickly. Donut graphs are a type of graph that is very useful for displaying data related to percentages. Following are the steps.

1. Prepare Data

The first step is to prepare the data to be displayed in the donut graph. The data can be in the form of percentage values from several different categories, or it can also be the amount of data that will be divided into several categories.

2. Create a Donut Graphic

Once the data is ready, the next step is to create a donut chart in Excel. To do this, select the data to be inserted into the graph and click on the “Insert” menu. Select the “Donut” chart type in the “Pie Chart” section.

3. Customize the Chart Appearance

Customize the appearance of the donut graphic to make it look more attractive and easier to understand. You can add titles, labels, and legends to donut graphics.

4. Change Chart Color

You can also change the color of each section in the donut graphic. Click on the section you want to change the color of, then select the “Format Data Point” option in the menu that appears. Select the desired color in the “Fill” section.

5. Add Animation Effects

To make the donut graphic livelier and more eye-catching, you can add animation effects to the graphic. Click on the part of the graphic that you want to give an animation effect to, then select the “Add Animation” option in the menu that appears.

6. Save and Share

Once the donut chart is complete, save your Excel file and share it with your friends or clients. Donut charts will be very useful to help them understand the data you are trying to convey.

7. Tips for Creating Attractive Donut Graphics

Here are some tips for creating attractive and easy-to-understand donut graphics: Use contrasting and easily distinguishable colors in each part of the graphic. Use fonts that are easy to read and large enough for titles and labels. Avoid using too many or too bright colors, as this can make the graph difficult to understand. Use simple animation effects and not too many, because too many animation effects can make the graphics overwhelming.

8. Example of Using Donut Graphics

Donut charts can be used in various contexts, such as to display percentages of survey results, the number of products sold in the last few months, or a comparison of the production costs of several products.

9. Benefits of Making Donut Charts in Excel

Here are some of the benefits you can get by making donut charts in Excel: Easy to use: Excel is one of the most frequently used programs for making graphs, so you don’t need to worry about technical skills in using this program. Flexible: Donut graphics can be adjusted to suit your needs, both in terms of appearance, color and graphic size. Easy to share: Donut graphics created in Excel can be saved in a variety of file formats such as PDF, JPEG, or PNG, making them easy to share via email or social media. Make it easier to understand data: Donut charts can make understanding complex data easier and simpler.

10. Disadvantages of Making Donut Charts in Excel

Even though it has many advantages, creating donut charts in Excel also has several disadvantages, including: Unattractive appearance: The appearance of graphs created in Excel sometimes looks less attractive and stiff compared to other programs that are more specific in creating graphs. Limited features: The features for creating graphs in Excel are limited when compared to other programs designed specifically for creating graphs. Difficult to modify: If you want to modify a chart that has been created, you need to reopen the Excel file and make changes manually.

11. Example of Making Donut Charts in Excel

The following is an example of creating a donut graph in Excel: Open the Excel program and enter the data you want to display in the donut graph. Select the data you want to insert into the donut chart and click on the “Insert” menu. Select the “Donut” chart type in the “Pie Chart” section. Customize the appearance of the donut graphic to make it look more attractive and easier to understand. Change the color of each section in the donut graphic. Add animation effects to donut graphics. Save your Excel file and share it with your friends or clients.

12. Tips for Creating Effective Donut Graphics

To create an effective donut graph, you need to pay attention to the following things: Make sure the data entered into the donut graph is valid and accurate. Choose the right graph type according to the data you want to display. Create donut graphics that are easy to understand and not confusing. Use consistent and easily distinguishable colors in each part of the graphic. Label each part of the graph to make it easier to understand. Avoid using excessive or too complicated animations. Make sure the donut graphic you create has an attractive and professional appearance.

13. How to Edit Donut Charts in Excel

If you want to edit a donut graph that has been created in Excel, you can do the following steps: Open the Excel file that contains the donut graph that you want to edit. Click on the donut graphic you want to edit. On the “Format” tab above the worksheet, select the “Format Selection” option. Use the options on the left of the screen to select specific elements you want to edit, such as colors, labels, or animation effects. Make changes as needed and click “OK” to save the changes.

14. How to Use Data Labels on Donut Charts in Excel

Data labels are labels added to each part of the donut graph to make it easier for readers to understand the data. Here’s how to use data labels on a donut chart in Excel: Click on the donut chart to which you want to add data labels. Select the “Add Chart Element” option on the “Design” tab above the worksheet. Select the “Data Labels” option and select the “Inside End” or “Outside End” option to determine the position of the data labels. Make changes to the appearance of data labels as needed, such as changing the font size or color. If you want to add specific labels to each part of the graph, use the “Value from Cells” option in the “Data Labels” option and select the cell that contains the label you want to add.

15. How to Use Animation Effects on Donut Charts in Excel

Animation effects can give a more attractive appearance to donut charts in Excel. Here’s how to use animation effects on a donut chart in Excel: Click on the donut chart to which you want to add an animation effect. Select the “Add Animation” option on the “Animations” tab above the worksheet. Select the animation effect you want to add to the donut graphic. Adjust the animation effect setting options in the “Animations” panel on the right of the screen. Preview the animation effects that have been added to the donut graphic by playing the presentation slide.

16. Conclusion

Creating donut charts in Excel is an effective way to visualize data and make understanding complex data simpler. When creating donut charts in Excel, you need to pay attention to the advantages and disadvantages of this program, as well as follow the tips for creating effective and professional donut charts. Apart from that, you can also use features in Excel such as data labels and animation effects to give a more attractive appearance to the donut graph you create. See you in other interesting articles!

Share This Post

Any question? Discuss with the author or other users