Dynamic range to update chart, multiple series

Hi Andy

Thanks for the reply, that is working great
Could I just ask, would there a be way to automatically update the chart when I added a new days worth of data in the end column?

Thanks again
Rich