Mastering Excel: Create Doughnut Charts in a Snap

Doughnut graphs, also known as ring charts, are a visually appealing way to represent data. They're particularly useful when you want to compare two categories or show a part-to-whole relationship. In this guide, we'll walk you through the process of creating a doughnut graph in Excel, step by step.

Before we dive in, ensure you have Excel installed on your computer. We'll be using Excel 2016 or later for this tutorial, but the steps should be similar in other versions. Let's get started!

Preparing Your Data

First, you need to organize your data in an Excel worksheet. For a doughnut graph, you'll typically have two categories of data. For example, you might want to compare sales by region (North, South, East, West) and by product type (A, B, C).

Your data should look something like this:

Creating a PivotTable

A PivotTable is a powerful tool in Excel that allows you to summarize, analyze, explore, and present large amounts of data. It's perfect for creating doughnut graphs. Here's how to create one:

1. Select your data, including the headers.
2. Go to the "Insert" tab, then click on "PivotTable".
3. Choose where you want to place the PivotTable (New Worksheet or Existing Worksheet), then click "OK".

Formatting the PivotTable

Now that you have a PivotTable, let's format it for our doughnut graph:

1. In the PivotTable Fields pane, drag "Region" to the "Rows" area.
2. Drag "Product A", "Product B", and "Product C" to the "Values" area. Ensure they're set to sum.
3. Right-click on any of the values in the PivotTable, then click "Value Field Settings".
4. In the "Summarize value field by" list, choose "% of Grand Total", then click "OK".

Creating the Doughnut Graph

Now that your PivotTable is formatted, it's time to create the doughnut graph:

1. Select any cell in the PivotTable.
2. Go to the "Insert" tab, then click on "Pie" or "Other Charts" (depending on your version of Excel), and choose "Doughnut".
3. Excel will create a doughnut graph based on your PivotTable data.

Customizing the Doughnut Graph

To make your doughnut graph more visually appealing and informative, you can customize it:

1. Click on the graph to select it, then go to the "Format" tab (in the "Chart Tools" section).
2. Here, you can change the colors, add data labels, or add a chart title.
3. You can also right-click on the graph and choose "Select Data" to modify the data source if needed.

And there you have it! You've created a doughnut graph in Excel. This visual representation of your data can help you and your audience gain insights more quickly and effectively. Happy data visualizing!