how to use microsoft excel to make a pie chart

#HOW TO USE MICROSOFT EXCEL TO MAKE A PIE CHART HOW TO#

The pie chart should now look like the 6th picture. Inside the 'Select Data Source' window, click the 'Switch Row/Column' button. Repeat steps 7 through 10 for Carbohydrate (using 'C' instead of 'B' values) and for Fat (using 'D' values) Note: When these steps are finished, the 'Select Data Source' window should look like the 5th picture.ġ2. The 'Select Data Source' window will pop back up.ġ1. Highlight the contents in the 'Series values' text box, then select cell B6 (The cell that has the SUM function inside it).ġ0. Highlight the contents In the 'Series name' text box, then select cell B2 (The cell with 'Protein' written).ĩ. Click the highlighted 'Add' option under 'Legend Entries (Series)' A different window will pop up with the title 'Edit Series' ('Add' button is called out in 3rd picture 'Edit series' window shown in 4th picture)Ĩ. A window will pop up with the title 'Select Data Source' (Window shown in 3rd picture)ħ.

Right-click on the white chart area so that a menu pops up (Shown in 2nd picture)Ħ. Now it's time to actually create the pie chart.ĥ. If you were tracking spending, you would put the cost of the item in the category it falls under, and leave other cells blank. My Excel workbook would then look like the 1st picture. In cell A3 I would write 'Crackers', in cell B3 I would type in '2', in cell C3 I would type in '11', and in cell D3 I would type in 6. Input the corresponding value for that category Example: Let's say I eat some 'Crackers' with 2.0 grams of protein, 6.0 grams of fat, and 11.0 grams of carbohydrate. Type the name of the item (For my example, I typed in that I ate 'Crackers' under 'Food Name'ģ. Note: You are not limited to only three cells to sum you can make your border as many rows as you like in the previous step, and sum as many cells as you think you need to track a day of eating, or a month of spending, etc.īefore we create our pie chart, let's input some data.Ģ. Once completed, your Excel workbook should look like what is shown in the 3rd picture. Note: The equations for cells C6 and D6 should respectively look like

Repeat steps 1 through 6 for the C Column (Select cell C6 and sum the cells C3 through C5) and the D Column (Select cell D6 and sum the cells D3 through D5). Press the 'Enter' key on the keyboard Note: If done correctly, the value in the sum cell (Cell B6) should be 0, and the equation in the cell should beħ. Drag the cursor down to cell B5 (At this point, Cells B3 through B5 should have a moving dashed-line around them, as can be seen by the call-out in the 2nd picture).Ħ. the word 'SUM' is a built in command in Excel that will sum all the values in a determined amount of cells.Ĥ. Note: the equals sign means that we want to assign a value or a function to this cell. Type in '=SUM(' without the quotation marks (Shown by the call-out in the 1st picture). Click on cell B6 (The first cell below the border in the B-column).Ģ. In this step, we will create the cells that sum all the values in one category.ġ. Since my original goal for making these instructions was to help people pay attention to what they eat, I will use the example of tracking the amount of protein, carbohydrates, and fat that are in foods eaten.

Just by making some simple alterations to the steps that will be shown, you can use this Excel format to measure and track just about anything! This Excel format could be used to track other things, like how much money you are spending on different types of goods, or how much time is spent on different tasks. What making this spreadsheet will allow you to do, is to input the number of grams of each category, and see what your daily intake of each of these categories are in percentages (shown by a pie chart). Let's say that you want to make sure that you're getting a healthy balance of protein, carbohydrates, and fats each day 20% protein, 50% carbohydrates, and 30% fat, for example.

#HOW TO USE MICROSOFT EXCEL TO MAKE A PIE CHART HOW TO#

The goal of these instructions is to walk you through step-by-step on how to make your own personal Excel spreadsheet that will allow you to track percentages of different things.

How to use microsoft excel to make a pie chart