Donut Progress Chart Excel Tutorial

Donut charts, with their distinctive circular shape and central 'hole', are a visually appealing and informative way to represent data in Excel. When combined with progress tracking, they become an excellent tool for monitoring key performance indicators (KPIs) and project milestones. This article will guide you through creating a donut progress chart in Excel, along with best practices and customization tips.

Before we dive into the creation process, ensure you have the latest version of Microsoft Excel installed on your computer. This guide uses Excel 2016 and Excel 365 as references, but the steps are generally similar in other versions.

Creating a Basic Donut Progress Chart

To begin, let's create a simple donut chart to track project progress. Assume we have the following data: Task, Completion Percentage, and Color for each task.

First, select the data range (including headers). Go to the 'Insert' tab, click on 'Pie' or 'Other Charts', and select 'Doughnut Chart'. Choose the first layout, which has a central hole.

Formatting the Chart

With the chart inserted, select it to reveal the 'Chart Design' tab. Here, you can customize various aspects of the chart. Start by clicking on 'Switch Row/Column' to ensure the tasks are displayed as slices around the circle.

Next, click on 'Format Selection' in the 'Chart Design' tab, then 'Format Selection' again in the pop-up menu. This opens the 'Format Selection Pane', where you can customize individual slices. Change the fill color to match your data, and adjust the border color and line thickness as desired.

Adding Data Labels and a Title

To make the chart more informative, add data labels by clicking on 'Add Data Labels' in the 'Chart Design' tab. Choose the label position that best suits your chart. Then, add a title by clicking on 'Add Chart Element' and selecting 'Chart Title'. Customize the title text and style as needed.

Customizing the Donut Chart

Now that we have a basic donut progress chart, let's explore some customization options to make it more engaging and informative.

Changing the Chart Type

Excel offers several donut chart variations, such as 'Doughnut Chart (Exploded)' and 'Doughnut Chart (3-D)', which can add visual interest to your chart. To change the chart type, select the chart, go to the 'Chart Design' tab, click on 'Change Chart Type', and choose your desired variation.

In the next section, we'll discuss how to create interactive donut charts using Excel's slicers and filters. Stay tuned!