Pie Charts
Excel Pie Charts
Pie charts display the data as circular slices.
Pie charts are a useful tool for displaying qualitative (categorical) data values.
Pie charts display how much each category contributed overall.
Note: Statistics Data Types has further information regarding qualitative (categorical) data.
Excel has two types of pie charts:
- 2-D pie (
) - Doughnut ()
2-D Pie Chart
Pie charts display the data as circular slices.
When there is just one data column, two-dimensional pie charts are employed.
Example
displaying the percentage of first-generation Pokemon that are Bug, Fire, Water, and Grass.
To keep up, you can duplicate the values:
- Select the range A1:B5
2. Select Pie (
) from the drop-down menu by clicking on the Pie menu (
) after selecting the Insert menu.
Note: To access this menu, expand the ribbon.
You should get the chart below:
A visual summary of the quantity of first-generation Pokemon of the grass, fire, water, and bug types is provided by the chart.
The types “Fire” in orange, “Water” in gray, “Bug” in yellow, and “Grass” in blue are displayed.
In the first generation, type “Water” has the most Pokemon.
Note: Labels can be added to the chart to make it unique. This may facilitate understanding of the distinctions between categories.
Doughnut Chart
The data is arranged in doughnut charts as slices of a circle with a hollow center.
When there are multiple data columns, doughnut charts are frequently utilized.
Note: The information displayed in a 1-column doughnut chart is identical to that in a 2-dimensional pie chart.
Example
The percentage of the types “Grass,” “Fire,” “Water,” and “Bug” is what we’re looking for. Take Pokemon Generation 1 and contrast it with the ratios in Generation 2.
To keep up, you can duplicate the values:
- Select the range A1:C5
2. Select Doughnut (
) from the drop-down menu by clicking on the Pie menu () after selecting the Insert menu.
Note: To access this menu, expand the ribbon.
Following the steps above, you will get the following chart:
A graphic summary of the quantity of first- and second-generation Pokemon of the grass, fire, water, and bug types is provided by the chart.
Pokemon from generation 1 are displayed in the inner circle, while those from generation 2 are displayed in the outside circle.
The types “Fire” in orange, “Water” in gray, “Bug” in yellow, and “Grass” in blue are displayed.
Pokemon of the “Water” type are the most prevalent in both generations, as this chart demonstrates.
Note: Labels can be added to the chart to make it unique. This may facilitate understanding of the distinctions among various types.
Note: It is impossible to determine which generation has more Pokemon based on this chart.
