how to create a pie chart with percentages of a list in excel

And the reason: Because it is circular! Even though your experts on visualization or design in your company might hate the pie chart, everyone loves it and they love seeing it! Of course, every graph can be considered visual, but a pie chart represents the data in a much clearer and illustrated way.Īlso, it is actually a scientific fact that people love the pie shape. One of the most important reasons that a pie chart is a highly used chart type is that it is visual. Let’s look at some of the reasons why it is one of the most used types of charts around the world by everyone. The circular pie and each of the pie slices sound fun. This meticulous calculation demands that every one percent (1%) of a component carries in the pie, it corresponds to an angle of 3.6 degrees. The pie mostly deals with the percentage rate while visually illustrating the comparison of data in a data group. And each slice of the pie represents each object’s contribution to the overall total of 100%.Įach component of the pie (that means each of the slices) are meticulously calculated to represent their comparison to other components in the pie.

It, unsurprisingly, gets its name because it is shaped like a real-life pie desert. Pie charts are circular graphs that exhibit the rate of different individuals, products, objects and categories.

How to create a pie chart with percentages of a list in excel