youtube how to make a pie chart in excel

Do not leave blank rows or columns when typing in the data. Type the numbers associated with each category into column B. For this example problem, the categories would be the type of pets, so type those into column A.

Type your categories in one column and your numbers into a second column.

Step 1: Type your data into an Excel worksheet. Pie Chart in Excel (updated through Excel 2016)Įxample question: Make a pie chart in Excel that represents what percentage of people in a certain town own certain types of pets: pet owners own, you can’t put a husky-German shepherd mix in two categories, otherwise it will create larger pieces of the “pie” for those categories. For example, if you have a chart of what breeds of dog U.S. Note: When you make a pie chart, you must make sure that your categories don’t overlap, otherwise you’ll have a meaningless chart. Two of the most popular programs for making charts in elementary statistics or AP statistics classes are Microsoft Excel and IBM SPSS Statistics: It isn’t really necessary with the wide variety of computer programs that can make pie charts for you. Pie charts can be tricky to draw by hand, especially with tricky percentages the whole of the pie is 360 degrees, so drawing 13.9 percent or 56 percent presents a challenge. In the above graph, percentages are the numerical variables and the type of trash are the categorical variables. In order to make a pie chart, you must have a list of categorical variables(descriptions of your categories) as well as numeric variables.

Youtube how to make a pie chart in excel