I am trying to replicate the pie chart found on this Office Template/Budgets/Personal Budget link in order to show total monthly income, total monthly expenses, and percentage of income spent on expenses.
I've created the worksheet including tables for income and expenses, but I can only get the pie chart to display the percentage of each of the values, relative to the total of both values. (I.e, expenses $3,000, income $6,000 - I can only get the pie chart to display 33% and 67%). The pie chart in the template link above is able to display the percentage of income spent, or would display 50% using the information from the example.
How do I get the pie chart to show the percentage of value A (monthly income) that value B (monthly expenses) comprises?
My table and current pie chart can be seen in my google drive.
I've created the worksheet including tables for income and expenses, but I can only get the pie chart to display the percentage of each of the values, relative to the total of both values. (I.e, expenses $3,000, income $6,000 - I can only get the pie chart to display 33% and 67%). The pie chart in the template link above is able to display the percentage of income spent, or would display 50% using the information from the example.
How do I get the pie chart to show the percentage of value A (monthly income) that value B (monthly expenses) comprises?
My table and current pie chart can be seen in my google drive.
