3

I have a list of dates that I would like create a histogram of.

date
5/21/2014
5/20/2014
9/16/2014
5/28/2014
6/8/2014
6/8/2014
5/28/2014
5/20/2014
8/11/2014
7/19/2014
8/11/2014

The chart's x-axis would be dates, the y-axis would be number of occurrences. Is this possible to do with Google Sheets or OpenOffice?

  • Possible, yes. Practical, maybe not. I believe you'd need to use one of the sorting and filtering methods from this tutorial to get a sorted list of dates without duplicates, and then use the COUNTIF function in an adjacent column to get the number of occurrences. Then you could graph the list of dates with associated numbers of occurrences. – Lyrl May 26 '15 at 16:07

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.