I need to plot the decay of my phone's battery against time over night. My starting time is 23:17:47 and my ending one is 07:05:49. I don't have any issue in changing the time format in the current one, selecting an XY chart and plotting time on the X axis.
The problem arises because Excel doesn't start the X axis at 23:17:47, but instead at 00:00:00, so my first value is drawn from the end of the graph and the goes back at the beginning when time values are over 00:00:00.
In other words, how do I set up the min time value to 23:17:47 and the max to 07:05:49 in excel?