I'm struggling with the best way to chart a series of times in Google Spreadsheets that involves a midnight crossover. The data in question is a graph of a bedtime, when the time to bed is after midnight the scaling of the chart becomes so great that important details and fluctuations in time are hard to see. Google Spreadsheets doesn't seem to support AM/PM format times natively in the y-axis, thus the use of 24-hour time.
Ideally, I would like to have the y-axis range from 6pm to 6am. Any thoughts or suggestions on how to do this?