Ever found yourself wishing you could represent your data in a more engaging, mouth-watering way? While Excel might not be the first tool that comes to mind when thinking about creating delicious-looking charts, it's actually surprisingly capable. Today, we're going to learn how to make a donut pie chart in Excel, a unique and eye-catching way to present your data.
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. Now, let's get started and create a donut pie chart that's sure to make your data look as irresistible as a fresh batch of donuts!
Preparing Your Data
First things first, you need to have your data ready in an Excel worksheet. For this example, let's assume we're tracking sales for three different products: Apples, Bananas, and Cherries. Our data might look like this:
| Product | Sales |
|---|---|
| Apples | 500 |
| Bananas | 350 |
| Cherries | 250 |
With our data set up, we're ready to create our donut pie chart.
Creating the Pie Chart
To begin, select your data, including the headers. Then, click on the 'Insert' tab in the ribbon. In the 'Charts' group, click on the 'Pie' button. Choose the first pie chart option, which is a standard pie chart.
Your data will now be displayed as a pie chart. However, it's not quite a donut yet. Don't worry, we'll fix that in the next step.
Converting to a Donut Chart
To turn our pie chart into a donut chart, we'll need to add a dummy series with a value of 0. This will create the 'hole' in the middle of our chart. Right-click on the chart and select 'Select Data'. In the 'Select Data Source' dialog box, click on 'Add' under 'Legend Entries (Series)`.
In the 'Edit Series' dialog box, enter a name for your new series (e.g., 'Donut Hole'), and set its value to 0. Click 'OK' to close both dialog boxes. Your pie chart should now look like a donut chart, with a blank center.
Customizing Your Donut Chart
Now that we have our basic donut chart, it's time to make it look even more delicious. We'll start by adding some color and changing the chart title.
Adding Color and Formatting
To add some color to your donut chart, right-click on one of the slices and select 'Format Data Labels'. In the 'Format Data Labels' pane, click on the 'Fill & Line' icon. Here, you can change the color of each slice to match your data. For example, you might make Apples red, Bananas yellow, and Cherries dark red.
To add a chart title, click on the 'Layout' tab in the 'Chart Tools' ribbon. In the 'Labels' group, click on 'Add Chart Element' and select 'Chart Title'. Enter your title (e.g., 'Fruit Sales by Category') and format it as desired.
Adding Data Labels
To make your donut chart even more informative, you can add data labels to each slice. Right-click on the chart and select 'Add Data Labels'. This will add labels to each slice, showing the percentage of total sales for each product. You can format these labels in the same way as the chart title.
To make the labels more engaging, you could add a small icon or image next to each label. To do this, right-click on a data label and select 'Format Data Labels'. In the 'Format Data Labels' pane, click on the 'Shape' icon and select an image from the 'Picture' library. Size and position the image as desired.
And there you have it! A mouth-watering donut pie chart that's sure to make your data stand out. Now that you know how to create a donut chart in Excel, why not try experimenting with different colors, images, and data sets? Happy charting!