Excel formula for a running balance with a minimum and maximum balace

Hi all, I am trying to create a graph displaying the water level in a tank. The tank is fed from rain which is collected on a roof. For my data, I have a table of rainfall at a given location. I wa...