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 yet underutilized tool in Excel that allows you to visualize two sets of data in a single, engaging chart. Let's dive into how to create one, step by step.
Before we begin, ensure you have the latest version of Excel installed on your computer. We'll be using Excel's built-in features, so no add-ins or macros are required. Let's assume you have two sets of data in columns A and B, with headers in row 1.
Preparing Your Data
Before creating the chart, it's crucial to structure your data correctly. For a double donut chart, you'll need to use a pivot table to combine your data into a single table with two columns for your data series.
Select your data (A1:B10, for example), then go to Insert > PivotTable. Choose where you want to place the pivot table, then click OK. In the PivotTable Fields pane, drag your first data series (Column A) to the 'Rows' area and your second data series (Column B) to the 'Values' area. Ensure that 'Values' is set to 'Sum'.
Creating the Donut Chart
Now that your data is ready, it's time to create the donut chart. Select any cell in your pivot table, then go to Insert > Recommended Charts. Excel will suggest several chart types; we're looking for 'Donut' or 'Pie'. Click on it to insert the chart.
By default, Excel will create a single donut chart. To turn it into a double donut chart, we'll need to add a second series of data. Right-click on the chart and select 'Select Data'. In the 'Select Data Source' dialog box, click 'Add' to add a second series. In the 'Edit Series' dialog box, enter a series name (e.g., 'Series 2'), select the pivot table cell containing the second data series, then click OK.
Formatting the Chart
Your double donut chart is now complete, but it's likely not very visually appealing. Let's spruce it up a bit. Right-click on the chart and select 'Format Selection'. In the 'Format Selection' pane, you can adjust the colors, fonts, and other visual elements of your chart.
To make your chart even more engaging, consider adding data labels or a legend. Right-click on the chart and select 'Add Data Labels' or 'Add Legend', depending on your preference.
Interpreting the Chart
Now that your double donut chart is complete, it's time to interpret the data. The inner donut represents the first data series, while the outer donut represents the second data series. The space between the two donuts represents the difference between the two data series.
For example, if the inner donut is 40% of the total chart size and the outer donut is 60%, it means that the second data series is 20% larger than the first data series. This can be a powerful way to visualize the relationship between two sets of data.
Creating a double donut chart in Excel takes a bit of practice, but once you get the hang of it, you'll find it's a powerful tool for visualizing data. So go ahead, impress your colleagues with your newfound charting skills!