Create Graph for each day from daily list.

Each day a new DEP (Departure) and ARR (Arrival) % figure is added to the enclosed file.
I have created a graph for all days, but would like an easy way of creating a DAILY graph which shows only the results for that day ie MONDAY. I don't want to rekey the data into separate columns for each day, so is there a way of extracting each days figures from the long list automatically in order to create a new daily graph, which can also be extended as the data list is added to. Thanks for any help. Kevin.

Convert your data to a list. Select the range, right click and pick Create List.

Apply Data > Filter > Autofilter.
Select the day you want to display.


In order to stop the chart resizing right click chart area and pick format Chart Area. On the properties tab set Don't move or size with cells.