Ever found yourself in a situation where you needed to compare two sets of data, but a simple bar or pie chart just didn't cut it? Enter the double donut chart, a powerful Excel tool that allows you to visualize data in a unique and engaging way. In this guide, we'll walk you through the process of creating a double donut chart in Excel, step by step.
Before we dive in, ensure you have the latest version of Excel installed on your computer. While the steps may vary slightly depending on the version you're using, the basic principles remain the same. Now, let's get started!
Preparing Your Data
Before creating your double donut chart, it's crucial to organize your data correctly. For this example, let's assume you have two sets of data: 'Sales' and 'Profit'. Both datasets should have the same categories (e.g., 'Region A', 'Region B', etc.).
![Doughnut Chart for Excel Dashboards: Simple and Easy way! [Excel Free Template]](https://i.pinimg.com/originals/96/41/32/964132c87ddaa7776b352d9791b759c9.jpg)
Your data should look something like this:
| Category | Sales | Profit |
|---|---|---|
| Region A | 5000 | 2000 |
| Region B | 6000 | 2500 |
Creating a Pivot Table
A pivot table is an excellent way to summarize and analyze your data. To create one, select your data and go to 'Insert' > 'PivotTable'. Choose where you want to place the pivot table and click 'OK'.
Now, drag and drop 'Category' into the 'Rows' section, 'Sales' and 'Profit' into the 'Values' section, and ensure they're set to 'Sum'. Your pivot table should look like this:
| Category | Sales | Profit |
|---|---|---|
| Region A | 5000 | 2000 |
| Region B | 6000 | 2500 |
Creating a Double Donut Chart
Now that you have your pivot table, it's time to create the double donut chart. Select any cell in the pivot table and go to 'Insert' > 'Recommended Charts'. In the 'All Charts' tab, scroll down to 'Other Charts' and select 'Doughnut'. Click 'OK'.
Excel will create a basic doughnut chart. To turn it into a double donut chart, right-click on the chart and select 'Select Data'. In the 'Legend Entries (Series)' section, click 'Add'. In the 'Series name' field, enter 'Profit', and in the 'Series X values' field, click the 'Collapse Dialog' button (the small arrow at the bottom of the field) and select the 'Category' column from your pivot table. Repeat this process to add the 'Sales' series.
Customizing Your Double Donut Chart
Now that you have your double donut chart, it's time to make it look great. Right-click on the chart and select 'Format Selection' (or press 'Ctrl + 1'). In the 'Format Selection' pane, you can customize the colors, labels, and more.
To make your chart even more engaging, consider adding a data label. Right-click on any slice of the chart and select 'Add Data Label'. You can then format the data labels to display the percentage or value of each slice.
Adding a Chart Title
A chart title can help viewers understand the purpose of your chart. To add one, right-click on the chart and select 'Add Chart Element' > 'Chart Title'. Enter your title and format it as desired.
Remember, less is more when it comes to chart titles. A clear, concise title can make a big difference in how your audience interprets your data.
Switching to a 100% Stacked Layout
By default, Excel creates a stacked doughnut chart. To create a true double donut chart, you'll need to switch to a 100% stacked layout. Right-click on the chart and select 'Format Selection'. In the 'Format Selection' pane, under 'Chart Design', click 'Switch Row/Column'. This will switch your chart to a 100% stacked layout, creating the double donut effect.
And there you have it! You've now created a stunning double donut chart in Excel. With a little practice, you'll be creating complex, engaging charts in no time. So go ahead, impress your colleagues and clients with your newfound skills!