Changing ranges in chart based on drop down

Hi,

Have a look at column AA. Underneath your tables I've added a new one. This table uses INDEX and MATCH to pull data from your original tables depending on which day is selected.

Hope that's of help.

BSB.