Making graph with time intervals on the x axis

I would make three tables that reference the main data data. each table should manipulate the time and intervals and collect data for that time interval and would, in turn, be the source of data for one of the three charts. I do not have any data from which to make an example so you may, if you want, email me the data you have. My email is in the Biography of my profile.

Kristian,

These are your headers:

the y axis you want to plot is to be binned data from what? The count of items in the bin? The tags? Are you only interested in actual volume of events?

Yup. so really.... the only column of interest is the "item_date"

Kristian,

This should be pretty straightforward...

We will start with the 24-hour bins. Create a table like this:

The first two rows are headers and the first column is a header. You can convert a row (or column) to a header by using the table formatter:

set up the first two rows as shown above and name the table as shown.

Now lets set up the Date column.

A3="4/2/2014"+$B$1×(ROW()−3)

this automatically creates bins for us to work with that are 1 day (24 hours)

the Forum cut me off. So this will finish the steps:

B3=COUNTIFS(Tabel 1::E, ">="&A3, Tabel 1::E, "<"&A3+$B$1)

select B3 and fill down.

to plot the data select column B then select the bar chart from the charts menu in the tool bar.

To make the 1 hour bins duplicate the table we just finished (the 24 hour bins) then change the contents of cell B1 from "1d" to "1h":

you will need to add cells to this table by selecting several rows (click, row 3, the "3" at the very left, then hold the shift key and click row 8). Now holf the option and the shift keys while repeatedly typing the down arrow to add rows until there are enough cells to cover the duration you want.

Repeat all this for the 15min bins.

Hi Kristian,

I've created a set of tables here too. Would you mind sharing the data with me also so I can chart?

My address is in my profile.

Jerry

Jerry,

What formula did you use?

I realize I have a question about the show time, so I need an answer before I can respond to Wayne.

You wrote above: - 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.

That makes it look like the show begins at 2000 on one day and finishes 5 hours later, at 0100 on the next day. Is that correct?

Jerry

OK, then when you say you want a count by hour on the show day, what time should that chart begin and end?