Hi,

I hava a chart that shows progress in the project. The horizantal line
represents the dates from the begining of the month to end(like 1 to 30) and
vertical line represents the number of the items. I enter new data everyday
based on progress in the project and I have to change the data source (Values
of the series) everyday by one by. I have 6 series and I have to change all
the series' value formula for example from J to K (Column J keeps yesterdays
data and K keeps todays) the next day K to L ans so on.

Is there any way to automate this prosess? I do not want to select from the
begining to end of the month data because the cells are zero after todays
data and the values are going to 0 and it do not look good in the report.

--
Thanks