Easy and no need to explain it to the end-user.With the help of each slice bar, we can easily compare one with another.Large data can be presented by using the Pie Chart in Excel.Step 6: Similarly, we can change the color of each bar, change the legends space, adjust the data label show etc.… Finally, your chart looks presentable to the reader or the user. We can change these data labels’ alignment to center, inside end, outside end, Best fit. We can show the series name along with their values, percentages. Step 4: Select the data labels we have added and right-click and select Format Data Labels. Step 3: Right-click on the pie and select Add Data Labels. Step 2: Now, it instantly creates the 3-D pie chart for you. Step 1: Select the data to go to Insert, click on PIE, and select 3-D pie chart. I have a sale person name and their respective revenue data. We can create a 3-D version of it as well. For this example, I have taken sales data as an example. Now we have seen how to create a 2-D Pie chart. 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. 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.

Pie charts in excel 2013