Update data source automatically

[Appache]

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.

 

[Bob Phillips]

Create a dynamic range name for each series and assign the them to the
series data sources.

For instance

=OFFSET($J$2,,,1,COUNTA($J$2:$AN$2))

as the refersto value of one of the names.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)