Skip to content

7. Visualize the Data and Make Decisions

Playback Speed:
Transcript

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.

Next arrow_forward
Instructions
  1. Highlight the categories and their totals in the summary table and insert a pie chart.
  2. Experiment with chart options.
  3. Change the fill color in spreadsheet rows for items that are essential.
  4. Open a new Google Doc and name it "Monthly Budget Evaluation."
  5. Write a paragraph evaluating:
    1. What did you spend the most money on?
    2. How much money did you have left over after all your expenses were paid?
    3. What would you do with that money?
    4. How would you save another 25 dollars a month?
    5. How do changes in one category affect spending in other categories?