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.

And got: terrible histogram

The axes labels are completely screwed up:

  1. It's formatted as numbers instead of dates!
  2. Some entries are greater than 1!

I've tried everything I can think of. How do I fix this?

  • I also tried asking on Quora, to no avail. – Ion Sme Jan 12 at 2:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.