Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I want to create a graph which given a list of dates, will produce a line graph representing the number of occurrences of list dates. For example, this would be ideal.

enter image description here

But when I try to recreate something like this in Excel (2013), I get a different result and can't figure out how to change the settings to achieve the desired result.

enter image description here

Is this desired graph possible in Excel, and if so, how do I go about doing it?

share|improve this question
1  
Related: superuser.com/q/595475/219090 –  Jerry May 18 '13 at 15:08
    
@Jerry your solution is actually much better than mine, I'd upvote it also if you summarised and added it here :) –  jay May 24 '13 at 16:50

1 Answer 1

up vote 3 down vote accepted

The graph you want to make is frequency and date, so you need to tabulate the frequency. To do this collect all the unique dates and calculate the frequency using COUNTIF.

=COUNTIF(range, criteria)

enter image description here

When you graph this you will get the graph you want

enter image description here


Update: Have a look at Jerry's answer to a similar question. A pivot table is ideal for a large and growing set of data.

share|improve this answer
1  
Thank you very much! –  Geesh_SO May 18 '13 at 13:28

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.