I have a budget spreadsheet, and have created a pie chart from the ‘category’ and ‘totals’ (£) columns.
I wanted the chart to show me the total amount spent on Utility Bills, Insurance, etc., per month but instead it is showing me the percentage spent in each type of bill.
I know that totals are possible because Apple shows this in a pie chart in one of their own budget templates.
I have Google-searched for the solution, to no avail.
Your help will be greatly appreciated.
Many thanks in advance.