Dynamic range to update chart, multiple series

You need to alter the named ranges slightly so the Row offset value is also dynamic based on the result of a MATCH formula.

I have add a data validation cell to the cash sheet that allows you to pick the account to report. The same cheque report is done on the other sheet.