I have 9 charts that take data from one worksheet, data comes in daily. The charts are monthy and have several data series, at the start of each month a new set of charts have to be started. Is there a quick way of telling the charts it should only collect data for Jan then the next set for Feb etc without manually having to set the data range for each series.

Thanks solti