Excel for Statistics > Pie Chart in Excel

Watch the video or read the steps below:

## Pie Chart in Excel

A pie chart is a way to display percentages of a whole. The entire “pie” represents 100 percent of a whole, while the pie “slices” represent portions of the whole. The size of each slice is proportional to that category’s percentage of the pie. 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. However, Microsoft Excel can help you create a pie chart in a minute or two.

**Sample question:** Make a pie chart in Excel that represents what percentage of people in a certain town own certain types of pets: dogs (1110 people), cats (987 people), rodents (312 people), reptiles (97 people), fish (398 people).

Step 1: **Type your data into a Microsoft Excel worksheet. **Type your categories in one column and your numbers into a second column. For this sample problem, the categories would be the type of pets, so type those into column A. Type the numbers associated with each category into column B. Do not leave blank rows or columns when typing in the data.

Step 2: **Select the data you entered. **To select the data, click the top left of your data and then drag the cursor to the bottom right.

Step 3: **Click “Insert,” then click “Pie,” **then click the type of pie chart you need. In most cases with simple pie charts like the one in this sample problem, the first selection (2D) will work fine. Once you have clicked the chart icon, Excel will insert the pie chart into your worksheet.

**Tip:** If you made a mistake in your entries, you don’t have to redo the entire chart; type your correction in the original data that you entered and Excel will automatically make the correction to the chart.

Check out our Youtube channel for more Excel/Statistics help.

Very Helpful information,

thanks.

Very easy to understand information! Helped me greatly during an ICT lesson!

VERY HELPFUL !!! THANKYOU

thankyou !!!

Really very helpful

Thank you ! So helpful, just in time! :)

Very nice helpful for me

it became funny for me. i had two variables yes 136, 44.9% and No 167, 55.1%. when i tried it, almost all the are of pie chart was for a No results and a very very small area just like a like represented the Yes. i was not contented. in which way can this be corrected

Kombi Godfrey

It sounds like the cells either have a/the wrong amounts or b/are formatted incorrectly (i.e. one as a decimal and one as a percent). Check both (right click on a cell to check the number format).