Basically, when I'm awake at 2 am, it's not that I've risen early, but rather that I have yet to go to bed.
When I graph data points with the time of day on the x-axis, it looks bizarre because data passed midnight appear at the beginning of the x-axis though they should be at the end (the end of my working day). I've attached a picture.
I'd like to make hours between midnight and 4 am display as being between 24:00 and 28:00.
How may I do that in Excel 2010?
Thanks!
Here's the attachment My messed up graph.png