writejnr.blogg.se

Then, select the type of Pie Chart you want.

Thirdly, select Insert Pie or Doughnut Chart from the Charts group.Īfter that, a drop-down menu will appear.Firstly, select the data range with which you want to make the Pie Chart.In this step, I will show you how you can insert the Pie Chart. Using Charts Group to Make a Pie Chart in Excelįor this method, I will use the Charts group to make a Pie Chart in Excel. I will make a Pie Chart using this dataset.ġ. This dataset contains the Course Name and Average Number of Present Students in 6 Months.

To explain this article, I have taken the following dataset. The first condition of making a Pie Chart in Excel is to make a table of data. Then select the paintbrush icon, Chart Styles.5 Simple Ways to Make a Pie Chart in Excel To change your pie chart color scheme, begin by selecting the pie chart. Legend Key: If you don’t have Category Name enabled, be sure to check this box so the legend appears at the bottom of your pie chart.Show Leader Lines: If the data label won’t fit entirely inside the slice, this option will add a line connecting the data label to the slice.What percentage of the whole pie does the slice represent? Checking this box will ensure that the slice is labeled with the percentage the slice represents. Percentage: This is often very useful.

In our example, that’s the dollar amount each poker player won. Each slice of the pie is labeled with the data value corresponding to that slide. Instead of having to refer to the legend, this option will label each slice of the pie with the category values.