how to create pie chart in excel from survey

The results of this survey are shown in the table below. If the average total number of pizzas ordered daily is 100, determine the average number of pizzas ordered for each variety of pizza. Vegetarian: Vegetarian (degrees) = Vegetarian order100360 Pepperoni: Pepperoni (degrees)= pepperoni order100360Ĭhicken: Chicken (degrees) = Chicken order100360 Hence the degrees of the sector represented by each pizza on the chart is calculated below: Mushroom: Mushroom orders = Percentage Mushroom order100Total number of pizza Vegetarian: Vegetarian orders = Percentage Vegetarian order100Total number of pizza Pepperoni: Pepperoni orders = Percentage pepperoni order100Total number of pizzaīeef: Beef orders = Percentage Beef order100Total number of pizzaĬhicken: Chicken orders = Percentage Chicken order100Total number of pizza Solution: The average number of pizzas ordered daily for each variety of pizza is calculated below Hence, use this information to calculate the degrees of the sector occupied by each pizza variety on the chart.

Mushroom: Mushroom (degrees) = Mushroom order100360Įxample 4: Construct two exploded pie charts from the information in Example 1 above. The first chart should emphasize the pizza with the highest daily orders, while the second chart should emphasize the pizza with the lowest daily orders. Solution: Pepperoni has the lowest daily order, and is exploded in the graph below. Named after a donut due to its resemblance to one, a donut chart helps to collect more complex data than a pie chart.

In other words, we may say that a donut chart is a superset of a pie chart. Pie charts are used to measure the proportion of the elements in a dataset.

HOW TO CREATE PIE CHART IN EXCEL FROM SURVEY HOW TO.

How to create pie chart in excel from survey