How to Make a Pie Chart With Microsoft Excel

1. Open a blank worksheet in Microsoft Excel.
2. Enter all of the data into one column starting with cell 'A1.' Using monthly expenses as an example, type 'groceries' in cell 'A1.' Navigate to the cell below ('A2') and type 'gas.' Continue moving down column 'A' typing 'utilities,' 'daycare,' 'car payment' and 'mortgage' in each cell.
3. Insert the total dollar amount you spend on each item. Move the cursor to cell 'B1.' Type the total monthly cost of gas in the cell. Continue down the 'B' column, inputting the monthly costs for each of your other expenses.
4. Put your cursor in the cell directly under the last dollar amount -- cell 'B7' in our example. Holding down the left mouse button, select the cells in this column above 'B7' all the way up to 'B1.' All of the dollar amounts should now be highlighted.
5. With the column still highlighted, click on the 'AutoSum' button along the top of your Excel worksheet. This will total the dollar amount column, displaying your total monthly expenses.
6. Put your cursor in cell 'A1' and highlight down to 'A6,' and then from 'B1' to 'B6.'
7. While the 'A' and 'B' columns are simultaneously highlighted, select the 'Charts' tab at the top of your worksheet. Then choose 'Pie' from the list of chart types.
8. You can select several types of pie charts. For Microsoft Excel's most basic pie chart, select the first option. Your chart will be instantly created in your worksheet.
9. To add percentages or other labels automatically, double-click on the pie chart. A dialog appears.
10. Click 'labels,' then select the desired type of labels, such as percentages or dollar values. Microsoft Excel will place percentages and names on the pie chart.