Creating visually appealing and informative charts in Excel can greatly enhance the presentation of your data. One such chart type is the percentage donut chart, which is perfect for showing proportions and comparisons. In this guide, we'll walk you through the process of creating a percentage donut chart in Excel, step by step.
![Doughnut Chart for Excel Dashboards: Simple and Easy way! [Excel Free Template]](https://i.pinimg.com/originals/96/41/32/964132c87ddaa7776b352d9791b759c9.jpg)
Before we dive into the process, ensure you have the data you want to visualize ready in an Excel worksheet. For this example, let's assume you have data on market shares of four companies: A, B, C, and D, with their respective percentages.
Preparing Your Data
To create a percentage donut chart, your data should be structured in a way that makes it easy to plot. Ideally, you should have one column for the company names and another for their respective percentages.
For instance, your data might look like this:
| Company | Percentage |
|---|---|
| A | 35% |
| B | 28% |
| C | 25% |
| D | 12% |
Formatting Your Data
Before creating the chart, it's crucial to ensure your data is formatted correctly. Select the percentage column, right-click, and select "Format Cells". In the dialog box that appears, select "Percentage" under the "Number" tab, and choose the desired decimal places.
After formatting, your data should look like this:
| Company | Percentage |
|---|---|
| A | 35.00% |
| B | 28.00% |
| C | 25.00% |
| D | 12.00% |
Creating the Donut Chart
Now that your data is ready, it's time to create the donut chart. Select your data, then click on the "Insert" tab in the Excel ribbon. In the "Charts" group, click on the "Pie" or "Other Charts" icon (depending on your Excel version), then select "Doughnut" from the list of chart types.
Excel will create a basic donut chart using your data. The next step is to customize it to show percentages.
Customizing the Donut Chart
To make your donut chart display percentages, you'll need to make a few adjustments. First, right-click on the chart and select "Select Data". In the dialog box that appears, click on the "Legend Entries (Series)" button.
In the "Edit Series" dialog box, you'll see that the "Series name" is set to "Percentage". Change this to "Company" so that your chart's legend reflects the company names instead of their percentages.
Adding Data Labels
To show the actual percentages on the chart, you'll need to add data labels. Right-click on the chart and select "Add Data Labels". Excel will add data labels to each slice of the donut chart, displaying the percentages.
However, these labels might not be formatted correctly. To fix this, right-click on the chart again, select "Format Selection", then click on "Data Labels" in the left-hand pane. In the "Data Label" pane, under "Number", select "Percentage". You can also adjust the decimal places and other formatting options here.
Customizing the Chart's Appearance
Now that your data is displayed correctly, you can customize the chart's appearance to match your preferences. You can change the colors of the slices, add a title, or even explode one of the slices to highlight a specific company.
To change the color of a slice, right-click on it and select "Format Data Series". In the "Format Selection" pane, you can choose a new fill color under the "Fill" section. You can also adjust the transparency and other visual effects here.
Once you're satisfied with your chart's appearance, you can resize it, move it to another location in your worksheet, or even copy it to another worksheet or presentation. Creating a percentage donut chart in Excel can help you and your audience better understand and interpret your data.
Now that you've mastered the art of creating percentage donut charts, why not explore other chart types in Excel? The more you practice, the more proficient you'll become, and the better your data visualizations will be. Happy charting!