how to make a pie chart in excel using select data

How to make a pie chart in excel using select data how to#
How to make a pie chart in excel using select data series#
How to make a pie chart in excel using select data download#

Intuitively, it would make more sense to have the smaller portions displayed in the stacked bar, leaving the larger portions in the pie.īesides this, the chart does not have labels to show the percentage contribution of each employee. Moreover, it takes John Smith’s portion out which is quite sufficiently large. You will notice that the chart does not look neat and organized.įor example, the chart shows Paula Lee’s portion within the pie, although her portion is quite small. Note: By default, the chart displays three data points in the stacked bar, unless you specify the number. This simplifies the pie, while the viewer can still see what the smaller sizes comprise of.įor example, in the chart shown below, the larger slices are visible in the main pie, while the smaller ones are grouped together into a single pie and then projected onto a bar chart, where you can still see the individual portions. However, as the number of categories increases, the pie chart starts becoming too complex to read.Ī ‘Bar of pie chart’ can be quite useful in such cases, as it lets you move the smaller slices of the pie to a separate stacked bar chart.

How to make a pie chart in excel using select data how to#

How to Convert a Pie Chart to a Bar of Pie ChartĪ pie chart is the best option when you want to visualize portions of a small number of categories (around 2-5).

Benefits of Using a Bar of Pie Chart in Excel.

Here we discuss how to create Pie Chart in Excel along with practical examples and a downloadable excel template. This has been a guide to Pie Chart in Excel. If there are too many values, try using a column chart instead.

If the labels are fewer, less we can compare easily with the other slices.

Try to explore each slice by a maximum of 8%.

Use a different color for each slice and make the chart look beautiful to watch.

This will be very much understandable to the users.

Instead of using legends, try to show them along with the data labels.

3D chart significantly distorts the message.

If there are too many things to show, it will make the chart look ugly.

Fitting data labels in the case of smaller values is very difficult.

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.

How to make a pie chart in excel using select data series#

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. 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.

How to make a pie chart in excel using select data download#

You can download this Pie Chart Excel Template here – Pie Chart Excel Template Example #1 – 2D Pie Chart in Excel