how to make a pie chart in excel equal 100 percent

We’ll review a few that offer quick but limited results with minimum effort. When you don’t want to display these values, you have a few choices, and some work better than others. Your data and the chart’s purpose will guide you in this decision. The steps are similar to what Susan Harkins describes in the following tutorial.Ĭharting 0s isn’t wrong, but you won’t always want to display them in your Excel charts.

For this demo, he uses Microsoft Office 365. This video will show how to create a frequency table and pie chart about beliefs about the impact of social media.Editor’s note: In the video, Brandon Vigliarolo walks you through a couple of ways for suppressing 0 values in Excel charts. A pie chart and bar chart of these results are shown below:Įxample 1: Creating a frequency table and pie chart in Excel 2016 on Out of a total of 128 responses, 41% (or 52/128) of students reported that Batman would win the battle, followed by Iron Man with 27%, Captain America with 19%, and Superman with 13%. Below is a frequency table and charts of the results: If you wish to perform an inferential test on the distribution of a single categorical variable, see the chi-squared goodness-of-fit test.Ī researcher asked her class to pick who would win in a battle of superheros. Frequency tables and bar charts can display either the raw frequencies or relative frequencies. Pie charts represent relative frequencies by displaying how much of the whole pie each category represents.

They are calculated by dividing the number of responses for a specific category by the total number of responses. Relative frequencies are more commonly used because they allow you to compare how often values occur relative to the overall sample size. These displays show all possible values of the variable along with either the frequency (count) or relative frequency (percentage). Frequency tables, pie charts, and bar charts can be used to display the distribution of a single categorical variable.

How to make a pie chart in excel equal 100 percent