M
marcel D
Hello, I've got next problem:
I'd like to make a graph of the level in a tank for the last 14 days.
Every day, I want to fill in the level of the tank in the sam
'fill-in' cell.
So for today, I fill in (for example) 20%. When the computer dat
changes, this 20% should shift one column to the left and the 'fill-i
field' becomes empty again. The next day, I fill in the new level o
the tank (15%). When date changes, this 15% should shift one cell t
the left and the 20% should shift again one cell to the left. ect.etc
After twenty days the 20% may be deleted.
For the date to change every day, I've got already a solution. The cel
above the fill-in field is =Today().
The cell on the left side =Today()-1 etc etc.
Does anybody know if I can maybe link the % of level in the tank to th
dates in the row above, or do I have to make a macro which is dat
triggered?
Thanks in advance and greetings,
Marce
I'd like to make a graph of the level in a tank for the last 14 days.
Every day, I want to fill in the level of the tank in the sam
'fill-in' cell.
So for today, I fill in (for example) 20%. When the computer dat
changes, this 20% should shift one column to the left and the 'fill-i
field' becomes empty again. The next day, I fill in the new level o
the tank (15%). When date changes, this 15% should shift one cell t
the left and the 20% should shift again one cell to the left. ect.etc
After twenty days the 20% may be deleted.
For the date to change every day, I've got already a solution. The cel
above the fill-in field is =Today().
The cell on the left side =Today()-1 etc etc.
Does anybody know if I can maybe link the % of level in the tank to th
dates in the row above, or do I have to make a macro which is dat
triggered?
Thanks in advance and greetings,
Marce