Dynamic Charts - help setting up with named ranges

Hello
It's difficult to add a series to a chart dynamically the way your data is set up. If you're happy to create an Excel Table then you can produce a chart which updates automatically but it requires the date to be pivoted round. Take a look at the attached file, on the Table tab the chart updates as you add new columns. It also allows you to filter the data and chart.

Hope this helps.
DBY