Graph drops to zero rather than leave gap where data is zero

Estevaoba
Forum Expert

solved the original problem of tracking over 30 days.

However, when I go to graph the data, the missing day drops to zero and makes the graph look funny.

I need leave a gap in the graph when there is missing data.


Thank you for your time and consideration.
Have a great weekend.

I am not at all sure how you created the axes... but not only was it returning to zero, butthe Y-axis was crazy.

Take pulse. The Y-axis suggests that the average value is almost 300. You wouldn't last a week with a pulse of 300! You'd explode...

Is this what you wanted? I changed the formulae in the light green cells.

Further options:

Do you want a break where there are no data, instead of a connecting line (as in the file)?

Do you find the #N/A errors unsightly (as in the file)? if so, conditional formatting can be used to hide them.

Your x-axis is a mess and is almost impossible to read. It would be easier to follow with JUST the date.