Ever wanted to visualize data in a unique and engaging way? Look no further than the donut graph, a circular chart that leaves a hole in the middle, allowing for a distinct and eye-catching presentation of your data. In this guide, we'll walk you through the steps to create a donut graph in Excel, enhancing your data analysis and storytelling capabilities.
Before we dive in, ensure you have a dataset ready. For this tutorial, let's assume we're working with sales data for different regions: North, South, East, and West. Let's get started!
Preparing Your Data
To create a donut graph, you'll first need to organize your data in a way that Excel can understand. For our sales data, we'll use a table with two columns: one for the region and one for the sales amount.
![Doughnut Chart for Excel Dashboards: Simple and Easy way! [Excel Free Template]](https://i.pinimg.com/originals/96/41/32/964132c87ddaa7776b352d9791b759c9.jpg)
Here's what your data should look like:
| Region | Sales Amount |
|---|---|
| North | 50000 |
| South | 65000 |
| East | 40000 |
| West | 70000 |
Creating a Pie Chart
Before we create the donut graph, we'll first create a pie chart, which will serve as the basis for our donut. Select your data, then go to the 'Insert' tab in the Excel ribbon. Click on 'Pie' and choose the pie chart style that best fits your data.
Once the pie chart is created, you'll notice that it's not quite a donut yet. Don't worry, we'll fix that in the next step.
Converting the Pie Chart to a Donut Chart
To create the donut effect, we'll remove the inner circle of the pie chart. Right-click on the chart and select 'Format Selection'. In the 'Format Selection Pane', click on 'Pie Chart' under 'Current Selection'. Then, under 'Format Selection', click on 'Add Chart Element' and select 'Chart Elements'. Finally, uncheck 'Chart Fill' to remove the inner circle.
Now you should have a donut chart! If you want to adjust the size of the donut hole, you can do so by changing the 'Exploded' value in the 'Format Selection Pane'.
Customizing Your Donut Chart
Now that you have a basic donut chart, it's time to make it your own. Excel offers a wide range of customization options, from colors and fonts to labels and legends.
To change the color of a slice, right-click on it and select 'Format Data Labels'. Then, under 'Format Selection', click on 'Fill' and choose the color you want. You can also add data labels, change the chart title, and adjust the legend to better represent your data.
Adding Data Labels
Data labels can help viewers understand the exact values represented by each slice of the donut. To add data labels, right-click on the chart and select 'Add Data Labels'. You can then format the labels to your liking, including changing the font, color, and size.
To display the percentage of the total represented by each slice, right-click on the data labels and select 'Format Data Labels'. Then, under 'Format Selection', click on 'Values' and select 'Percentage'.
Changing the Chart Title and Legend
To add or change the chart title, right-click on the chart and select 'Add Chart Element', then 'Chart Title'. You can then format the title to your liking. To change the legend, right-click on it and select 'Format Legend'. Here, you can change the legend position, fill, border, and text.
And there you have it! You've successfully created a custom donut chart in Excel. This unique visualization can help you and your audience better understand and engage with your data. Happy data visualizing!