Ever found yourself in a situation where you need to visualize data progress, but a simple bar or line chart just doesn't cut it? Enter the progress donut chart, a powerful tool that can help you illustrate data trends and percentages in a unique and engaging way. In this guide, we'll walk you through the steps to create a progress donut chart in Excel, no add-ins required.
Before we dive in, ensure you have a basic understanding of Excel's built-in features, particularly the ones we'll be using: Excel's Recommended Charts, the Format Selection pane, and a bit of basic Excel formula knowledge. Let's get started!
Setting Up Your Data
First things first, you need to organize your data in a way that Excel can understand. For a progress donut chart, you'll typically need two columns: one for the category or label, and another for the corresponding percentage or value.
Here's a simple example:
| Category | Percentage |
|---|---|
| Sales | 65 |
| Marketing | 30 |
| Support | 5 |
Creating the Donut Chart
Now that your data is set, it's time to create the chart. Here's how:
1. Select the data you want to plot. In our case, that's A1:B4.
2. Click on the 'Insert' tab in the Excel ribbon, then click on 'Recommended Charts'. Excel will display a list of suggested charts based on your data.
3. Look for the 'Donut' chart type in the list. It should be under the 'All Charts' tab. Click on it to insert the chart.
Customizing the Donut Chart
Excel's default donut chart might not be exactly what you're looking for. Let's customize it:
1. Click on the chart to select it. This will bring up the 'Chart Design' tab in the Excel ribbon.
2. In the 'Chart Design' tab, click on 'Format Selection' to open the Format Selection pane on the right side of the screen.
![Doughnut Chart for Excel Dashboards: Simple and Easy way! [Excel Free Template]](https://i.pinimg.com/originals/96/41/32/964132c87ddaa7776b352d9791b759c9.jpg)
3. Here, you can customize various aspects of your chart, such as the fill color, border color, and size of the donut rings. You can also add data labels, change the chart title, and more.
Adding Data Labels
Data labels are a crucial part of a progress donut chart. They help viewers understand the exact percentage or value represented by each segment of the donut.
Here's how to add them:
1. Select the chart to bring up the 'Chart Design' tab.
2. In the 'Add Chart Element' group, click on 'Data Labels', then 'More Data Label Options...'.
3. In the Format Data Labels pane, check the box for 'Show Data Labels'. You can also customize the label position, font size, and color here.
Formatting Data Labels
By default, Excel will display the data labels as percentages. If you prefer to display them as actual values, you can do so with a simple formula:
1. Right-click on one of the data labels and select 'Format Data Labels'.
2. In the Format Data Labels pane, under 'Label Options', click on the 'Value From Cells' icon.
3. In the 'Value From Cells' dialog box, enter the formula `=Sheet1!B2*100` (replace 'Sheet1' with the name of your sheet and 'B2' with the cell containing your first percentage).
4. Click 'OK'. Repeat this process for each data label, adjusting the cell reference as needed.
And there you have it! You've successfully created a progress donut chart in Excel. This chart type can help you tell a compelling data story, making it an invaluable tool for presentations, reports, and more. Happy charting!