Click the Pie option, and your chart is created. Ill show you how to create a chart that isnt a Quick Analysis option, shortly.

Excel displays recommended options based on the data in the cells you select, so the options wont always be the same. Step 4: Modify the appearance (optional). To create a pie chart, select the cells you want to chart.

The doughnut chart will automatically update with a second outer layer: In the new window that pops up, click Add to add a new data series.įor Series values, type in the range of values fpr Quarter 2 revenue:Ĭlick OK. Right click on the doughnut chart and click Select Data. Step 3: Add a layer to create a double doughnut chart. The following doughnut chart will automatically appear: On the Data tab, in the Charts group, click the icon that says Insert Pie or Doughnut Chart. Perform the following steps to create a double doughnut chart in Excel.Įnter the following data into Excel, which displays the percentage of a company’s revenue that comes from four different products during two sales quarters: This tutorial explains how to create a double doughnut chart in Excel. It’s similar to a pie chart except it has a hole in the center, which makes it look more like a doughnut.Ī double doughnut chart is exactly what it sounds like: a doughnut chart with two layers, instead of one. A doughnut chart is a circular chart that uses “slices” to display the relative sizes of data.

Create pie chart in excel two columns