how to make a pie chart in excel for expenses

Set up the big-picture pie that fits your situation and your future goals.

But that teeters on categorized budgeting, which I am not all about! Again, setting some amount I should spend, whether it be on my mortgage or my shoes just doesnt sit well with me. Granted, our discretionary spending wedge there includes gas, groceries & other food spending, entertainment, etc that tend to be separated out in others recommended budget percentages.

Then type in those categories and percentages to the Canva tool. Think about what is relevant for your family.įor each pie wedge category on your list, calculate how much you spend as a percentage of your income annually. Be thoughtful about how you divvy up to make a good big-picture visual of what your total annual income is doing.īut if you arent a binge clothing shopper, theres no reason to pour over your account statements for the past year finding all your clothing purchases just because other people budget that separately. But you could separate out groceries if you wanted to keep a closer eye on any particular important or problem categories. For example, I put all spending as one category. Make big-picture categories that fit into the context of your life, lumping things together where that makes sense to you, separating pieces out that you feel need separate attention.

You can also use the free pie chart maker tool from Canva.

How to make a pie chart in excel for expenses