We have seen how cool the Excel doughnut chart is when we compare it to the pie chart. Add Legends to the left-hand side and make chart title as Mobile Sales Presentation.Įxample #2 – Doughnut Chart in Excel with Two Data Series.I have changed according to my interest, and my chart looks like this. Change the color of each slice to a nice color.Uncheck everything and select the only Percentage. On the right-hand side, you will see format data labels. Now select the newly inserted Data labels and press Ctrl + 1.Right-click on the slice and add Data Labels.Make the angle of the first slice as 236 degrees and Doughnut Hole Size as 60%.It will show you the Format Data Series on the right-hand side. Select all the slices and press Ctrl + 1. Now, we need to modify this doughnut chart to make it beautiful to see.Now, we have the default doughnut chart ready.Go to INSERT Charts PIE Under Select Doughnut.Note: I am using Excel 2013 for this article How to Create a Doughnut Chart in Excel?īelow are the examples of the Doughnut Chart in Excel.įollowing are the steps for creation of doughnut chart in excel using single data series – In this article, I will show you the process involved in creating a doughnut chart. 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 allowing us to create more than one data series. Moreover, it can contain more than one data series at a time. PIE occupies the entire chart, but in the doughnut chart center of the slices will be cut out, and the center of the chart will be empty. In this circular chart, every category of data has its part, and all the categories make it as a whole circular data. What is Doughnut Chart Excel?ĭoughnut Chart is a part of a Pie chart in excel Pie Chart In Excel The pie chart is a circular excel chart representing the visualization of data in a circular format. Doughnut chart is a type of chart in excel whose function of visualization is just similar to pie charts, the categories represented in this chart are parts and together they represent the whole data in the chart, only the data which are in rows or columns only can be used in creating a doughnut chart in excel, however it is advised to use this chart when we have less number of categories of data.
0 kommentar(er)
