Enclosed you will find an Excel-workbook; in which I have deployed a lookup-functionality. (Pls see: B15:B18). By manipulating these variables the graph will show the corresponding values.
What I would like to ask for your help on is to make the 'series look-up range' dynamic. Like, if I choose a more current period, then, the graph will be printed to the far-right; and vice-versa. 'Problem' is that the graph picks up empty values; and hence I would like it to pick up values only for the active date-range period. Not a static range; but a dynamic one that is controlled by the date-range I have chosen.