Now, we must select the newly inserted data labels and press “Ctrl + 1.” On the right-hand side, we may see “Format Data Labels.” Uncheck everything and choose the only “Percentage.”.After that, right-click on the slice and select “Add Data Labels.”.Make the “Angle of the first slice” 236 degrees and the “Doughnut Hole Size” 60%.

Select all the slices and press “Ctrl + 1.” It will show us the “Format Data Series” on the right-hand side. We need to modify this doughnut chart to make it beautiful.Now, we have the default doughnut chart ready.We need to go to “Insert,” “Pie Chart,” and select “Doughnut.”.We must first select the full data range.The following are the steps for the creation of a doughnut chart in Excel using single data series: Note: We are using Excel 2013 for this article. In this article, we will show you creating a doughnut chart. For example, in the pie chart, we need to create two pie charts for two data series to compare one against the other, but doughnut makes life easy for us by creating more than one data series. Moreover, it can contain more than one data series at a time. A pie occupies the entire chart, but it will cut out the center of the slices in the doughnut chart, and it will be empty. There are multiple kinds of pie chart options available on excel to serve the varying user needs. However, it is advised to use this chart when we have less number of categories of data.ĭoughnut Chart is a part of a Pie chart in excel Pie Chart In Excel Making a pie chart in excel can help you with the pictorial representation of your data and simplifies the analysis process. We can only use the data in rows or columns in creating a doughnut chart in Excel. The categories represented in this chart are parts, and together they express the whole data in the chart. A doughnut chart is a chart in Excel whose visualization function is similar to pie charts.

Create pie chart in excel 2010