Mastering Excel: Create Stunning Donut Charts with Percentages

Creating a donut chart in Excel with percentages can be a powerful way to visualize your data, making it easier to understand and present. This type of chart is particularly useful when you want to compare parts of a whole or show progress towards a goal.

In this step-by-step guide, we'll walk you through the process of creating a donut chart in Excel with percentages, using a simple dataset as an example. By the end, you'll be able to create engaging and informative donut charts to enhance your data storytelling.

Preparing Your Data

Before creating your donut chart, ensure your data is well-structured and formatted. For this example, let's assume you have a dataset with two columns: 'Category' and 'Percentage'.

Here's how your data might look:

Converting Text to Numbers

Excel treats percentages as text by default. To perform calculations and create a chart, you'll need to convert them to numbers.

Select the cells containing the percentages, click on the 'Home' tab in the ribbon, then click on 'Format as Table'. In the 'Create Table' dialog box, check 'My table has headers' and click 'OK'. Now, click anywhere in the table, go to the 'Design' tab under 'Table Tools', and click on 'Convert to Range'. In the 'Convert to Range' dialog box, uncheck 'My table has headers' and click 'OK'.

Formatting Percentages as Numbers

With your data now in a range, select the percentage cells, right-click, and select 'Format Cells'. In the 'Number' tab, choose 'Percentage' with no decimal places, and click 'OK'.

Creating the Donut Chart

Now that your data is properly formatted, you're ready to create your donut chart.

Select your data, including the headers. Go to the 'Insert' tab in the ribbon, click on 'Pie' or 'Other Charts', then select 'Doughnut' (or 'Pie' and then change it to a donut chart later). Excel will insert a default pie chart. We'll modify it to create a donut chart.

Changing the Chart Type

Right-click on the chart, select 'Change Chart Type'. In the 'Change Chart Type' dialog box, select 'Doughnut' under 'All Charts'. Click 'OK'.

Customizing the Chart

To make your donut chart more engaging, you can add a title, change colors, and adjust the legend. Right-click on the chart, select 'Add Chart Element', and choose the elements you want to add or modify.

To show percentages on the chart, right-click on a slice of the donut, select 'Add Data Labels'. Then, right-click on the data labels, select 'Format Data Labels'. In the 'Format Data Labels' pane, under 'Label Options', check 'Value From Cells', and select the range containing your percentages. Click 'Close'.

Congratulations! You've created a donut chart in Excel with percentages. This chart will help you and your audience better understand and compare the data.

Now that you know how to create a donut chart in Excel with percentages, you can apply this skill to other datasets, making your data presentations more engaging and informative. Happy charting!