Making a Pie Chart in Excel



Creating a Pie Chart in Excel

| | |

|CLB Level: 3/4 |Method: |

| |Students refer back to their budget (done previously) |

| |As a class, review budgets and the purpose of having a plan for one’s money |

|Essential Skills Focus: |Discuss how much money/percentage of income should go to housing, groceries, etc. For |

|Computer Use (Using Excel) |example: 30% of income should go to housing (which includes utilities) |

|Numeracy (Money/Percentage) |Ask students what they spend the most amt. of money on? The least amount? Where they |

|Thinking Skills (Finding Info) |would like to spend more money? Where they’d like to spend less money? Discuss |

| |miscellaneous expenses |

|Task: Transfer information from a personal budget to|Explain to the students that you are going to take the numbers on their budget and |

|a Pie Chart |present them in a different way; using a pie chart and the students will represent data|

| |as a proportion or part of the whole thing |

|Purpose: |Pie charts are used in the work place: especially in the business world and sales. |

|Students will become familiar with Excel: charts |They are also used for budget allocation and for population representation |

|Students will see how much their fixed and variable |Hand-out the accompanying worksheet and go through the activity, step-by-step with the |

|expenses are as a dollar amt. as well as a |students |

|percentage of their overall spending | |

| |Follow Up: Discuss with students how a pie chart is helpful. It’s an easy diagram to |

|Materials: |read and gives people a clear picture of the date in a matter of minutes. Discuss what |

|Computer with Excel |‘stands-out’ for them on their pie chart. What are things they can tell immediately |

|Prior material: students need to know the |from scanning budget pie-charts? |

|categories of their spending (rent, groceries, | |

|loan…etc.) and approx. how much money they spend for|Debrief/Transfer: |

|each/month |Continue helping students become familiar with |

| |Excel and with Pie Charts by inputting different |

|Learning Style: |data: ex. countries/continents where students in |

|Visual |class are from. |

| | |

|Time: 1-2 lessons | |

Making a Pie Chart in Excel

1. In column A, enter category types (housing, food/groceries, travel, etc)

2. In column B, enter values corresponding to category types ($300, $200, $100, etc)

3. Highlight all cells containing information in column A and B

4. Press the Chart Wizard button on the toolbar [pic], or click on the Insert menu and choose Chart

5. When the Chart Wizard opens up, choose the Pie chart type

6. Click Finish to insert the pie chart onto the spreadsheet

7. You should now have a chart similar to below:

[pic]

8. Hover over the graph, right click and choose Format Data Series

9. Choose the tab Data Labels

10. Check off the options Category Name and Percentage and press Okay

[pic]

11. Your graph should now look like the following:

[pic]

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download