How to Set Up Data for a Doughnut Chart in Excel
Doughnut charts, like pie charts, show segments of your data and how those segments relate to the whole. Unlike pie charts, which show the breakdown for one data series, doughnut charts can plot more than one data series. Each time you add a data series, Excel will create an additional ring inside the doughnut. Although Excel does all the hard work for you in creating the doughnut chart, you still need to set up your data correctly to take advantage of Excel's slick charting features.
Other People Are Reading
Instructions
-
-
1
Open Excel to a blank workbook.
-
2
Create labels for one variable in each column. For example, if you want to compare sales figures for different years, enter the heading for each year in a different column. Year "2008" might be in cell B1, "2009" in cell C1, and "2010" in D1.
-
-
3
Create labels for the second variable in each row. For example, if you want to compare the sales figures not only across different years, but across different regions as well, enter the heading in each row. For example, "Northeast" might be in cell A2, "Midwest" in cell A3, "South" in cell A4, and so on.
-
4
Enter the data inside the table you created. Excel treats the numbers in each column as a single "ring" of the doughnut that will add up to 100 percent. Each row is treated as a different ring.
-
5
Select the entire table you created and click the "Insert" tab on the ribbon. Click the doughnut icon and select a doughnut chart from the list. Use the Design, Layout and Format tabs to customize your doughnut chart further.
-
1
