How to Create a Donut Chart in Excel

Ever found yourself wishing you could visualize your Excel data in a more engaging way? Donut charts, with their circular design and central opening, can provide a unique perspective on your data. Let's dive into how to create a donut chart in Excel, step by step.

Before we begin, ensure you have the latest version of Excel. The process may vary slightly depending on your version, but the core steps remain the same.

Preparing Your Data

First, let's ensure your data is ready for the chart. Donut charts work best with a single series of data. So, if you have multiple series, you might want to combine them into one using the SUMIF or SUMIFS functions.

For this example, let's assume you have a simple dataset in cells A1 to A5 with the heading "Sales" and corresponding sales figures in B1 to B5.

Creating a Pie Chart

Donut charts are essentially pie charts with a hole in the middle. So, our first step is to create a pie chart.

Select your data (A1:B5), then click on the 'Insert' tab in the ribbon. In the 'Charts' group, click on 'Pie' and choose the first pie chart option. Your pie chart should now appear on the sheet.

Converting the Pie Chart to a Donut Chart

Now, let's convert this pie chart into a donut chart. Right-click on the chart and select 'Format' from the context menu. In the 'Format Selection' panel that appears on the right, click on the 'Add Chart Element' dropdown, then 'Chart Fill'.

In the 'Chart Fill' pane, click on the 'No Fill' option. This will create a hole in the middle of your pie chart, turning it into a donut chart.

Customizing Your Donut Chart

Now that you have a basic donut chart, it's time to make it your own. You can change the colors, add data labels, or even explode a slice to highlight a particular point.

To change the color of a slice, right-click on it and select 'Format Data Labels'. In the 'Format Data Labels' pane, click on the 'Fill' dropdown and choose your desired color.

Adding Data Labels

Data labels can provide additional context to your chart. To add them, right-click on the chart and select 'Add Data Labels'. You can then format these labels to your liking.

Remember, less is often more when it comes to chart design. Too many colors or labels can make your chart look cluttered and confusing.

Exploding a Slice

Exploding a slice can draw attention to a particular point in your data. To do this, right-click on the slice you want to explode and select 'Format Data Point'. In the 'Format Data Point' pane, drag the 'Explode' slider to the desired extent.

Exploding a slice can be particularly effective when you want to highlight a significant change or anomaly in your data.

And there you have it! You've now created a engaging and informative donut chart in Excel. Don't be afraid to experiment with different colors and styles to find what works best for your data. Happy charting!