Hi All,

Take the following scenario:
- Cells B1 - Y1 I have the dates Jan-16 - Dec-17
- Cells B2 - Y2 I have my accounts receivables balance at the end of the respective months of the rows above
- Cell A1 I have a data validation list that gives me the option of selecting any month between Jan-17 and Dec-17

I want to create a waterfall chart that shows only the last 12 months receivables balance, ending with the month selected in the drop down list (cell A1). So for example, if I were to select Mar-17 from the drop down list in cell A1, the waterfall chart would show the months Apr-16 - Mar-17. Similarly if I were to select the month Nov-17 from the drop down list, the chart would then only show data for the months Dec-16 - Nov-17.

This is part of a financial dashboard I am creating as part of my monthly accounts review. Thanks in advance.