How to create pie chart in excel with words
In this way, we can present our data in a PIE CHART makes the chart easily readable. Step 12: Now, you can expand the Pie Explosion according to your wish. Right-click on the pie and select Format Data Series. Step 11: You can expand each pie differently. 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.
HOW TO CREATE PIE CHART IN EXCEL WITH WORDS SERIES
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