how to make a pie chart in excel of percentages

Manual method: Go to insert > Select pie chart Step 1: Select the data for which you want to apply a pie chart Imagine you have a portfolio of six products and you want to measure sales for each, the sum of each product’s sales value equals the amount. Perhaps pies are commonly used as we all like things to be whole and figure out how the various pieces relate to the whole. Visualize a pie chart (variety is left to your choice) here each slice represents an element and all slices put together look a whole.

How to spot whether my data is better served as something other than pie.Ī pie chart conveys the part-to-whole relationship of your data.Two cases where a pie becomes necessary.Good thing is that it has a proper use case and also ease to use. Pie charts are commonly used under data visualizations. If you want to add more sense to your data then start using pie charts. You can create a part-to-whole relationship with each product’s contribution towards sales with the help of a pie chart. Imagine you have a portfolio of seven products and you want to measure sales for each, the sum of each product’s sales value equals the amount.

How to make a pie chart in excel of percentages