Ever found yourself wishing you could visualize your data in a more engaging way? Look no further than the stacked donut chart, a creative and insightful way to display your data in Microsoft Excel. In this guide, we'll walk you through the process of creating a stacked donut chart, step by step. Let's dive right in!
Before we begin, ensure you have your data ready in an Excel spreadsheet. For this example, let's assume we're working with sales data for three products: Apples, Bananas, and Cherries, over a period of four months.
Preparing Your Data
To create a stacked donut chart, your data should be structured in a way that allows Excel to understand the hierarchy. In our case, we'll use a table with months as rows and products as columns, with the sales figures in the intersecting cells.
Here's what our data looks like:
| Apples | Bananas | Cherries | |
|---|---|---|---|
| Jan | 100 | 150 | 75 |
| Feb | 120 | 180 | 90 |
| Mar | 150 | 200 | 110 |
| Apr | 180 | 220 | 130 |
Creating a Stacked Area Chart
Our first step is to create a stacked area chart, which will serve as the base for our donut chart.
Select your data, then click on the 'Insert' tab in the Excel ribbon. In the 'Charts' group, click on 'Area' and then 'Stacked Area'. Excel will insert a stacked area chart based on your data.
Converting to a Donut Chart
Now that we have our stacked area chart, we'll convert it into a donut chart. Right-click on the chart and select 'Format Selection'. In the 'Format Selection' pane, under 'Chart Tools', click on 'Change Chart Type'. In the 'Change Chart Type' dialog box, select 'Donut' from the list of chart types. Excel will convert your stacked area chart into a stacked donut chart.
Customizing Your Stacked Donut Chart
Your chart is now ready, but it might not be as visually appealing yet. Let's customize it to make it more engaging and informative.
Right-click on the chart and select 'Select Data'. In the 'Select Data Source' dialog box, you can change the order of your data series to control the order of the slices in your donut chart. You can also add or remove data series as needed.
Adding a Data Label
To make your chart more informative, you can add data labels to show the exact sales figures for each slice. Right-click on the chart and select 'Add Data Labels'. Excel will add data labels to your chart.
To make the data labels more readable, you can format them. Right-click on a data label and select 'Format Data Labels'. In the 'Format Data Labels' pane, you can change the font, size, and color of the data labels, and even add a border or fill color.
Adding a Chart Title
A chart title can help viewers understand what they're looking at. To add a chart title, click on the 'Layout' tab in the Excel ribbon. In the 'Labels' group, click on 'Chart Title'. Excel will add a chart title to your chart. You can then click on the chart title and type in your title.
And there you have it! You've just created a stacked donut chart in Excel. This engaging and informative chart type is perfect for showing parts of a whole, and it's sure to impress your colleagues and clients. Happy charting!