I've tried making a histogram of my data, which looks like so:
12:00:02 PM 3:00:00 PM 12:30:00 PM 12:30:00 PM 2:00:00 PM 3:00:00 AM …
I highlighted the data and selected insert > chart > histogram.
The axes labels are completely screwed up:
- It's formatted as numbers instead of dates!
- Some entries are greater than 1!
I've tried everything I can think of. How do I fix this?