How to Turn Your Google Sheets Budget into a Simple Spending Chart

Home > Blog > AI Tools > How to Turn Your Google Sheets Budget into a Simple Spending Chart

Your budget sheet can be correct and still hard to read. You scan down a column of pounds, see Rent at £850, Groceries at £300, and a handful of smaller amounts, and you still walk away without a clear picture of where the money actually goes. A Google Sheets spending chart fixes that gap, because it turns those same rows into shapes you can compare at a glance, with the largest cost standing out right away.

In this guide

• Step 1: Pick only the cost rows for your chart
• Step 2: Insert the chart
• Step 3: Choose a pie chart for spending shares
• Step 4: Check the chart against your table
• Reading your chart
• Fixing a wrong chart
• Common mistakes to avoid
• Quick check before you finish
• Final thoughts

Step 1: Pick only the cost rows for your chart

Open the budget sheet you already use. This guide uses the same example as the monthly budget guide: income of £2,200, then six cost rows, Rent £850, Groceries £300, Transport £130, Bills £210, Fun £110, and Savings £200. Those six planned costs add up to £1,800.

In that layout, the cost names sit in column A, from row 3 to row 8, and the planned amounts sit beside them in column B, also from row 3 to row 8. Click cell A3, then drag down and across to cell B8, so both the names and the planned amounts are selected together.

Leave the other rows out on purpose. Do not include the Income row, because income is not spending, and it would dwarf every cost slice. Do not include the Total out row either, because that row repeats money already counted in the six costs. Do not include the Actual column for this first chart, so the chart shows one clear set of numbers: what you planned to spend.

Step 2: Insert the chart

With cells A3 to B8 still selected, click Insert at the top of the sheet, then click Chart. Google Sheets adds a chart to the sheet and opens the chart editor on the right-hand side.

If the chart editor is not showing, double-click the chart. That brings the editor back, so you can change the chart type or its data range without starting over.

Step 3: Choose a pie chart for spending shares

In the chart editor, click Setup if it is not already open. Under Chart type, click the down arrow to open the list, then choose Pie.

A pie chart suits this job because Google describes it as a way to show data as slices of a pie, or proportions of a whole. Your question here is a share question, not a date question: out of all your planned spending, how much goes to rent, and how much goes to groceries? A pie answers that question in one shape, with each cost as one slice.

Keep the chart simple at this stage. You do not need a second chart for the same six rows, and you do not need to add the Actual column yet. One pie, built from one set of planned amounts, is easier to read than two charts pulling in different directions.

Step 4: Check the chart against your table

Before you trust the chart, match it back to the table, slice by slice. The largest slice should be Rent, because £850 is the largest planned cost. The smallest slice should be Fun, at £110. Groceries, at £300, should be the second-largest slice, followed by Bills at £210 and Savings at £200, which should look close in size, with Transport at £130 below them.

Also check the slice labels. Each slice should carry one of the six cost names: Rent, Groceries, Transport, Bills, Fun, and Savings. If you see Income, Total out, or a blank label, the chart is reading the wrong rows, and the fix is in the Fixing a wrong chart section below.

Reading your chart

With the example numbers, the first thing the pie shows is how much of the plan goes on housing. Rent at £850 is almost half of the £1,800 planned total, so its slice takes up almost half the pie. That is the point of the chart: a fact that was easy to skim past in a table becomes hard to miss in a shape.

Groceries, at £300, is about a sixth of the planned total, so its slice is much smaller than Rent but clearly larger than the rest. Bills and Savings sit close together, which makes sense, because £210 and £200 are close amounts. Transport and Fun are the thin slices at the edge of the pie, and that is useful too, because it stops a small cost from feeling as large as a big one.

Read the pie as shares of planned spending, not shares of income. Income is £2,200, but it is not in this chart, so the slices add up to the £1,800 of planned costs, not to your pay. Savings appears as a slice for the same reason: in this budget, savings is a planned row, money set aside on purpose, rather than money left over by chance.

Use the chart to ask one plain question: does this split look like the month I want? If Rent and Groceries together already take up most of the pie, there is little room left for anything else, and that is a planning point to notice, not a reason to redraw the chart until it looks better.

Fixing a wrong chart

Most wrong charts come from a wrong range, not from a wrong chart type. The data range is the set of cells the chart reads, and Google Sheets lets you change it in the chart editor. Double-click the chart, click Setup on the right, then, under Data range, click the grid icon. Select the cells you want the chart to use, then click OK.

For this budget, that correct selection is A3 to B8: the six cost names and their planned amounts. Work through the common faults against that range. If one giant slice is labelled Income, your range starts a row too high, at row 2. If a slice is labelled Total out, your range runs a row too low, to row 9. If the slices have numbers but no names, your range is missing column A, so add the names back in.

If the chart looks crowded with twice as many slices as you expected, check whether both the Planned and Actual columns are in the range. For this first chart, keep only the Planned column, so each cost appears once. If you later want a chart of actual spending, build it from the Actual column in the same way, as a separate chart, rather than mixing planned and actual amounts in one pie.

When an amount in the table changes, change it in the table cell, not in the chart. The chart reads the cells in its data range, so a corrected amount in column B will show up in the chart without you having to rebuild it.

Common mistakes to avoid

• Charting income and costs together, so income swallows every spending slice.
• Including the Total out row, which counts the same money twice and makes the pie add up to more than your spending.
• Selecting the whole sheet, or whole columns, instead of just the six cost rows, so totals and blank rows end up in the chart.
• Choosing a chart type first and never checking its slices against the table, so a wrong range goes unnoticed.
• Leaving Savings out of the chart, then wondering why the slices do not match the planned total of £1,800.

Quick check before you finish

You should finish with one pie chart built from A3 to B8, with six slices labelled Rent, Groceries, Transport, Bills, Fun, and Savings. Rent should be the largest slice, Fun the smallest, and there should be no slice for Income and no slice for Total out.

Read the chart once more against the table: Rent £850, Groceries £300, Transport £130, Bills £210, Fun £110, and Savings £200. If a slice does not match its row, go back to Setup, check the data range, and correct it before you share the sheet or print it.

Final thoughts

Try this with your own budget sheet this week, even if your amounts are rough. Pick just the cost rows, insert the chart, choose Pie, and check the slices against the table. Once you can see, in one shape, that one or two costs take up most of your spending, the next decision about your budget gets a lot easier to make.

Related guide

If you have not set up the budget sheet yet, start with How to Use Google Sheets to Track a Monthly Budget in 20 Minutes.

For another simple way to make everyday tools easier to scan, see also: How to Organise Gmail with Labels and Filters in 15 Minutes.