Trying to Create Meaningful Graphs

[alemoo2016]

Hi team,

I have an expense tracker and I'm trying to make a graph for a specific category of expenses, to track how much money was spent on that category for a given range of time. For example, how much was spent on fast food for the month of July. Please see the screenshot. I'm wondering if there is a way to make multiple graphs for each category I want to track, or maybe there is an option to have several drop-down menus to select the date range, the category, which bank account it happened in, and the total amount spent.

I tried working on a formula like this here but I think I might not be going in the correct direction for this goal, seeing as how it only summarizes my expenses and I would have to manually do this for every category. What if I also spent money from my cash account on Fast Food? Then I would need the ability to add that query into there also.
=SUMIFS(H5:H76,F5:F76,"o",G5:G76,"sco-chq",I5:I76,"Fast Food")

Thanks in advance

[BlindAlley]

Can you post a small sample file, without any names or bank account numbers ? There is an easy way of doing this but without a file to work on it becomes very time consuming for anyone trying to help.

[alemoo2016]

Here is a sample file

[BlindAlley]

OK, I will have a look at the sheet for you.

[BlindAlley]

Take a look at this and see if a) this is workable for you or b) it IS workable but you would like more / less detail or c) I should just go to the LCBO grab some beers and watch the Poo Jays:-)

[alemoo2016]

Take a look at this and see if a) this is workable for you or b) it IS workable but you would like more / less detail or c) I should just go to the LCBO grab some beers and watch the Poo Jays:-)

I'm sorry, there was a family emergency and I spent the past three days in a hospital hours north of home...I'm just getting back. I'll review this soon and will get back to you soon. I'm still leaning towards beer.

[alemoo2016]

Take a look at this and see if a) this is workable for you or b) it IS workable but you would like more / less detail or c) I should just go to the LCBO grab some beers and watch the Poo Jays:-)

Strange, I had replied to this over two weeks ago...I don't see my reply here.
Thanks very much for the file. It does exactly what I need
I'm going to tweak it for my needs
Much appreciated