Ever found yourself wishing you could visualize your data in a more engaging and unique way? Doughnut graphs, with their circular design and ability to show both numerical and proportional data, can be a great solution. Here, we'll guide you through the process of creating a doughnut graph in Excel, step by step.
Before we dive in, ensure you have Excel 2016 or later, as the process involves using the RECOMMENDED CHART feature, which is not available in earlier versions. Also, have your data ready, with categories in one column and their corresponding values in another.
Preparing Your Data
For a doughnut graph, you'll need your data in a specific format. Let's assume you have a dataset like this:
| Category | Value |
|---|---|
| Apples | 40 |
| Bananas | 35 |
| Cherries | 25 |
Sorting Your Data
![Doughnut Chart for Excel Dashboards: Simple and Easy way! [Excel Free Template]](https://i.pinimg.com/originals/96/41/32/964132c87ddaa7776b352d9791b759c9.jpg)
Sort your data by the values in descending order. This will ensure that the largest value is at the top, making your doughnut graph easier to read.
To sort, select your data, go to the 'Home' tab, click on 'Sort & Filter', then 'Sort Largest to Smallest' under the 'Value' column.
Creating a PivotTable
A PivotTable can help you transform your data into a format that's easier to visualize. Select your data and go to the 'Insert' tab. Click on 'PivotTable', choose where you want to place it, and click 'OK'.
In the 'PivotTable Fields' pane, drag 'Category' to 'Rows' and 'Value' to 'Values'. Ensure 'Value' is set to 'Sum of Value' and click 'OK'.
Creating the Doughnut Graph
Now that your data is ready, let's create the doughnut graph.
Inserting the Chart
Select the PivotTable and go to the 'Insert' tab. Click on 'Recommended Charts' in the 'Charts' group. Excel will suggest various chart types based on your data. Look for a doughnut chart and click on it.
Customizing the Chart
Once your doughnut chart is inserted, you can customize it to fit your needs. Right-click on the chart and select 'Select Data'. In the 'Legend Entries (Series)' section, click 'Add'. This will allow you to add a new series, which you can use to create the doughnut hole.
In the 'Edit Series' dialog box, enter a name for your new series (like 'Doughnut Hole'), and in the 'Series X values' field, enter a single value (like 1). In the 'Series Y values' field, enter 0. Click 'OK', then click 'OK' again to close the 'Select Data Source' dialog box.
Your doughnut graph is now complete! You can further customize it by changing the chart style, adding titles, or adjusting the layout. Don't forget to update your data if needed, and your doughnut graph will update automatically.
Creating a doughnut graph in Excel can help you present your data in a unique and engaging way. Whether you're showing market shares, sales by region, or any other data that can be broken down into categories, a doughnut graph can make your data stand out. Happy charting!