Mastering Excel: Step-by-Step Guide to Create Doughnut Charts

Doughnut charts, with their distinctive ring shape, are an excellent way to visualize data, especially percentages. Microsoft Excel, a powerful spreadsheet software, allows you to create these charts with ease. In this guide, we'll walk you through the process of creating a doughnut chart in Excel, step by step.

Before we dive in, ensure you have the data you want to visualize ready in your Excel worksheet. For this example, let's assume you have data on sales by region: North, South, East, and West.

Preparing Your Data

Doughnut charts are best suited for displaying parts of a whole. In our case, we want to show the percentage of total sales each region represents.

First, calculate the total sales by using the SUM function. Then, in a new column, divide each region's sales by the total sales to find the percentage. For instance, if North's sales are $50,000 and the total sales are $200,000, the formula in the percentage column would be "=50000/200000".

Creating the Doughnut Chart

Now that your data is ready, it's time to create the chart.

Selecting the Data

Highlight the data you want to plot, including the headers. For our example, select the region names and their corresponding percentages.

Once selected, click on the 'Insert' tab in the Excel ribbon. In the 'Charts' group, you'll see various chart types. For a doughnut chart, we'll use the 'Pie or Doughnut' option.

Choosing the Doughnut Chart

In the 'Pie or Doughnut' group, click on 'Doughnut'. Excel will insert a basic doughnut chart based on your selection.

You'll notice that the chart has a legend. If you prefer a cleaner look, you can remove it. Right-click on the legend and select 'Delete'.

Customizing the Doughnut Chart

Now that you have a basic doughnut chart, let's make it more visually appealing and informative.

Adding Data Labels

Data labels show the exact values or percentages on the chart itself. To add data labels, right-click on the chart and select 'Add Data Labels'.

You can also format these labels to make them more readable. Right-click on a data label and select 'Format Data Labels'. Here, you can change the font size, color, and other formatting options.

Changing the Colors

Excel automatically assigns colors to your chart. If you want to change these, right-click on a slice of the doughnut and select 'Format Data Series'. In the 'Fill' section, you can choose new colors.

You can also apply a consistent color scheme throughout your chart. Right-click on any color in the 'Standard Colors' section and select 'Fill Effects'. Here, you can choose a color scheme and apply it to all slices.

Congratulations! You've just created a professional-looking doughnut chart in Excel. This chart will help you and your team visualize your sales data more effectively.

Remember, the key to a good chart is keeping it simple and easy to understand. Don't overload it with too much data or complex formatting. Keep experimenting with different chart types and customizations to find what works best for your data.