This will add all the values we are showing on the slices of the pie.

Step 10: Now, right-click on one of the slices of the pie and select add data labels. Step 9: This is not yet the fully finished chart. Countries names are ranging from A2 to A11. Horizontally we need to show all the countries names. Step 7: Here, we need to select the values that we need to show horizontally. In the Series Values, I have selected all the countries percentage values ranging from B2 to B11. In the Series Name, I have selected the heading as a percentage. Step 4: once you click on Select Data, it will open the below box. Step 3: Right-click on the chart and choose Select Data. Step 2: once you click on a 2-D Pie chart, it will insert the blank chart as shown in the below image. Step 1: Do not select the data rather, place a cursor outside the data and insert one PIE CHART. I have chosen a PIE CHART to represent slices of PIE.įollow the below steps to create your first PIE CHART in Excel. The first column contains a country name, and the second column contains the population percentage. I have a top ten country population percentage over the world population. You can download this Pie Chart Excel Template here – Pie Chart Excel Template Example #1 – 2D Pie Chart in Excel

How create pie chart in excel