Making graph with time intervals on the x axis

Hi there,

I have a very long table (approx. 3000 rows) showing time and dates for tweets (from Twitter) made around a danish television show, which I have to transform into a graph. My question is how do I do that the smartest way with Numbers?

- I have to create a graph showing the total number of tweets made from two days before the show to two days after the show. (The show was on 4th of April. So the graph has to show the number of tweets on the 2nd, 3rd, 4th, 5th & 6th of april.). I'm thinking a bar chart. But how can I tell Numbers to put all tweets from e.g. the 2nd into a bar called "2nd" on the x axis?

- I have to create another graph showing the total number of tweets made across the day of the show. So the x axis would be in 24 hour intervals. (E.g. all the tweets from between 12.00 - 12.59 would go into a point on the x axis called "12".)

- I have to create a third graph showing the number of tweets made during the show. So the x axis would be in quarters (15 min intervals) from 20.00 - 01.00. (E.g. all the tweets from between 12.00-12.15 would go into a point called "12.00-12.15" on the x axis.)

Is there a smart way to control the time intervals on the x axis or do I really have to cound e.g. all tweets from 12.00-12-15 and then again all tweets from 12.15-12-30 etc.?

Hope this makes sense and there is a clever person out there somewhere who can tell me how to do this in a smart way 🙂

Best regards
Kristian Vestergaard

Denmark