7. Visualize the Data and Make Decisions

attachment

Students can submit work

In this video, you will add a chart to your spreadsheet to help you visualize expenditures from the fictitious bank account.

Then, you will make decisions about the expenditures and identify at least one area where you could save money.

You already created a summary table that shows the categories you named and the amount of money you spent in each category.

To create a pie chart from this table, select the category data in the summary sheet.

Then, insert a chart.

Select the pie chart and insert the chart into your spreadsheet.

Select the chart to move and resize it so that it does not cover any data in the spreadsheet.

Experiment with the chart options to make it more legible and to suit your tastes.

Add a title to the chart if you’d like.

You can change the colors and fonts, and even the chart type.

Categorizing your expenses and visualizing them on a chart or graph helps you see spending patterns.

If you spend a lot of money at restaurants, for example, you might decide to eat in more to save money.

If this were your bank account, where could you reduce spending and save more money?

Now, it’s your turn: Highlight the categories and their totals in the summary table and insert a pie chart.

Experiment with chart options.

Evaluate the budget.

Then, move on to the next page to reflect this activity.