How to crop a break in a time progression chart?

I was testing a laptop battery usage (as opposed to charging) and was hoping to show a chart to the person for who I did that; I set the X axis to minutes-from-start and for Y axis %/hr (drop). I unfortunately had to put the testing on hold, so I made an entry right before putting the laptop to sleep, and made the next one right after “awakening” it (is that the term?).

In the attached
portable-essai_batterie.ods (27.5 KB)
one can see that in between the 2 entries surrounding the sleep that there’s a long downward slope ending up close to 0, as opposed to ~22 for the rest. I’d like for the chart to not show anything about the break, that the long slope be cropped. I tried multiple methods to do it on my own but I can’t manage to do it.

Thank you kindly for your help

Btw, “waking it up” instead of “awakening it”.

You could set E10 to =NA() or just enter any text into the cell. Both are not displayed as data point.

But note that your time calculations are wrong, a time difference / duration multiplied by 24 does not yield a value in minutes, even less when formatted as [HH]:MM:SS. For “Minutes depuis dernière heure” just use the difference, like in C3 =$A3-$A2 and copy-paste down. Similar for “Minutes depuis début”, in D3 =$A3-$A$2 and copy-paste down. For “Diminution % / min” calculate in E3 =($B2-$B3)/$C3/1440 if you really want a per minute value (you’d have to format to 0.00 to not see only 0 …), but the chart’s Y-axis suggests %/hr so that could be =($B2-$B3)/$C3/24 instead and the column header be “Diminution % / hr”. Or the Y-axis and title are wrongly labelled. If I understood your intention correctly at all…

After removing the formatting on the time, I did a couple modification as you suggested, as in the attached
laptop-test_battery.ods (30.8 KB)
With E10, it became a long flat (or almost) line which I’d like for that to be cropped so the 2 points surrounding the sleep are–immediately–one after the other, like 1 min have passed in between. With C3 the 1st entry in the graph shot up, which if was reflecting reality would mean the battery would be drained from full in < 10 mins, which is wrong as it lasted hours.

I then translated the spreadsheet so you might have a better understanding of what I’m trying to do with it. Please let me know if you need me to do other modifications in order for you to better help me.

You misunderstood. You should had C3 copy-pasted down to C4:C11 and also doing all other adjustments I lined out. Instead, you destroyed the calculation and formatting :p
See attached the result I think would suit your intention, which I’m not sure of.
portable-essai_batterie-fixed.ods (24.7 KB)

This
portable-essai_batterie-3.ods (24.6 KB)
is exactly what I wanted.

Thanks for the tips.