I enter the degrees F reading each morning and the degrees C column appears automatically. I have a graph generated from the date and the two temperature columns. There are generally a week or two of spare rows awaiting the figures.
By setting the Hidden and Empty Cell Settings to Show empty cells as Gaps any forward dates are not graphed and terminates at the latest date - for the degrees F line at least. However the degrees C line, for future dates drops to the zero axis and continues along that axis to the end.
The formula I use in the C cells is
=IF(B45="","",(B45-32)*5/9)where B45 is the corresponding Fahrenheit cell.
It would seem that having a formula there, even if it results in a null entry, doesn't count as an empty cell for the purposes of stopping the graph line dropping to zero.
Any thoughts on how to achieve this? I could remove the formulas from the forward Celsius cells but would prefer not to.