Plot time against Weekday

I have 2 colums, colum A with Weekday (monday-sunday) calculated from date's. In colum B I have a different time for each row. My data consists of a few weeks and i'm not really interested in the date itself but more in the moment in the week. The time are times from posted tweets. What I want is to create a graph that shows on which moment in the week tweets were post, so the 7 days on the X-axis and the time on the Y-axis, this way I can see if people are more active on Twitter during weekends or evenings instead of during working days or during the day.

Thanks!

Here is an example

Thanks for your reply. It helped me going, but it hasn't fully solved my problem yet. Because I want to be able to add a second line into the same graph to compare two different datasets, but this is not possible (I think because the width of the x-axis is not equally distributed?)

Thanks for your help so far!

Attached is an example of what I mean. Basically it's the same, only now I have 2 datasets (colum A&B and colum C&D). I want both datasets to be in the same graph with 2 different lines.

I managed to do it! I added a number (1 and 2) for the different datasets as a new variable and just pasted the 2nd dataset under the first 1, than created 1 pivot table out of that and used that to create the chart. Only (small) problem remains that the scaling isn't quite right, because it only scales for the values that it has in the dataset, so not with equal intervals (24h/day).

I'm not sure how to do that, because the Pivot table gets the time values from the dataset, so if the appropriate time values don't exist in the dataset, can it that still show them? (for example monday 2 am is not in the dataset, can it that still be displayed in the table, with 0 matches.)

Never mind, i figured it out! Great, thanks for all the help I've got!