Creating a pie chart that will group duplicate headings

[Jumiric]

I am using a spreadsheet to manage my finances. I want to be able to add expenses/income on the fly and use a chart to monitor how much I'm spending in each category, however, when I create charts, they never group up the duplicate headings. Google, Microsoft, and my Intro to Comp teacher were not able to help much. I've gathered that I may be able to use some kind of formula or macro to create a column of totals that could be used for a chart. Does a function that would help with this exist or would I need to reformat my template? I'm using Excel 2013. Thank you in advance for your attention.

 

[Jumiric]

bump