Excel: Create Doughnut Chart from Non-Adjacent Ranges

Creating a doughnut chart in Excel to visualize non-adjacent ranges can be a powerful way to present your data. This type of chart is especially useful when you want to compare parts of a whole, or show data that is related but not sequential. Here's a step-by-step guide to help you create a doughnut chart based on non-adjacent ranges in Excel.

Before we dive into the process, ensure that your data is structured correctly. Non-adjacent ranges refer to data that is not contiguous or consecutive. For instance, you might have sales data for different regions, but the data for each region is scattered across different cells. To create a doughnut chart, you'll first need to consolidate this data into a single range.

Preparing Your Data

Consolidating non-adjacent ranges involves using Excel's built-in functions or features. Here, we'll use the Remove Duplicates and Flash Fill features to clean up our data.

Let's assume you have sales data for four regions (North, South, East, and West) scattered across different cells. First, select the entire range of cells containing your data. Then, go to the 'Data' tab and click on 'Remove Duplicates'. This will remove any duplicate entries and consolidate your data into a single range.

Using Flash Fill

Now, let's use Flash Fill to separate the region names from the sales figures. Select the column containing the combined data, then go to the 'Data' tab and click on 'Flash Fill'. Excel will automatically separate the data into two columns - one for the region names and one for the sales figures.

Once your data is consolidated and separated, you're ready to create your doughnut chart.

Creating the Doughnut Chart

Select the data range, including the headers. Then, go to the 'Insert' tab and click on 'Pie' or 'Other Charts' and select 'Doughnut'. Excel will insert a default doughnut chart based on your data.

However, the default doughnut chart might not be exactly what you want. To customize your chart, right-click on it and select 'Select Data'. In the 'Select Data Source' dialog box, you can change the series by clicking on the 'Switch Row/Column' button if your data is structured differently. You can also add or remove series as needed.

Formatting Your Doughnut Chart

Now that you have the basic doughnut chart, it's time to make it look professional. Right-click on the chart and select 'Format Selection' or 'Format Chart Area'. This will open the formatting pane on the right side of your screen.

Here, you can change the colors of the slices, add data labels, or explode a slice to highlight a particular region. You can also change the chart title, axis titles, and legend to better represent your data. Don't forget to add a title that clearly explains what your chart is showing.

Customizing the Doughnut Hole

One of the unique features of a doughnut chart is the hole in the middle. By default, Excel fills this hole with a solid color. To make your chart more engaging, you can add a chart element to the hole, such as a picture or another chart.

To do this, right-click on the chart and select 'Add Chart Element' and then 'Insert Sliced Chart'. This will insert a small chart into the hole. You can then format this chart to match your data or add a relevant image.

Creating a doughnut chart based on non-adjacent ranges in Excel can help you present your data in a clear and engaging way. By following these steps, you can create a professional-looking chart that effectively communicates your data story. So, go ahead and give it a try! Remember, practice makes perfect, so keep experimenting with different data sets and chart customizations to find the best way to visualize your data.