Large data can be presented by using the Pie Chart in Excel. 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. Select the data labels we have added and right-click and select Format Data Labels. Now, it instantly creates the 3-D pie chart for you. 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. For this example, I have taken sales data as an example. We can create a 3-D version of it as well.
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.
Now, you can expand the Pie Explosion according to your wish. Right-click on the pie and select Format Data Series. This will add all the values we are showing on the slices of the pie. Now, right-click on one of the slices of the pie and select add data labels. 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. 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. Once you click on Select Data, it will open the below box. Right-click on the chart and choose Select Data.
Once you click on a 2-D Pie chart, it will insert the blank chart as shown in the below image.