TIL how to make SQL-like queries on data in Google Sheets, which is making my anxiety-driven finance-reviewing much weirder.
Give your chart a "NamedRange" name (Data | Named Ranges), then you can call QUERY() which takes 2 arguments: the NamedRange (in my case "Spending") and the query you want (in my case this is selecting the dollar amount in column F from any row where the store name @ column B is my liquor store).
I'm SUMming that QUERY and dividing by a certain number of days (@ B24) to get a "$AMOUNT spent at $STORE per-day" value.
=SUM(QUERY(Spending, "select F where B = 'ABC Liquors'"))/B24
(It's not good.)