Excel Check Register

Hello! I've been using the Excel Check Register with the Pie chart that shows percentages of where your money goes. It's a great tool, but I cannot get the chart to recognize Deposit categories. There's a built in DEPOSIT category, but I need to break it up into Investment, Income, Interest, etc. Each category has a function to pull the info from your register and it shows =CategoryTotal in the TOTAL column, but I can't figure out the method for setting up that SUM process for any other category. Does that make sense???? ;0/