I’m looking to ultimately set up a bar chart that allows me to visualize my cash flows on a monthly basis historically. The Monthly Analysis tab has these values for the last 12 months, but I can’t quite figure out how to get the cash flow amounts by month for all time in a table to use as the source data. Ideally this automatically adds on each additional month as new data comes into the workbook.
Any help and guidance would be appreciated.