Want to chart all data as points for monday through sunday on chart. Excel sheet included.

Hello guys! Good to be apart, I hope I learn a lot to come.

I'm trying to make a chart using a pivot chart or scatter plot. I'm not sure why my chart is only plotting 5 days of the week and only using 5 values. My data is using 2 columns for data. Column B are the days of the week. I'm interested in plotting a dot for each time and day there is data for. So for example: Each time a car drives by I note the time I recorded it and the day of the week as well. So at 9:40am on a wednesday I recorded a car that drove by.

I want the chart to reflect a dot or bar for each time and day there is data for. (For reach time and day a car drove by.)
If the chart is showing correctly it would show the greatest times of day the traffic is the highest.


There will be duplicate days. So There may be several thursdays with 2:00pm data. I'm interested i duplicate data being reflected as well.
The problem is that the chart is showing all seven days but it's only plotting seven points of data, or bars.

so value data would be for example:
12:05am
12:15am
3:00am
3:05am
5:15am
7:00am,
10:00am
12:00pm
1:55pm
4:00pm
etc...

Axis data is:
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday

There may be hundreds of 12:00pm Saturdays, or hundreds of 2:55pm Tuesdays, etc.
I would like all of them to reflect a dot or bar on the chart.

I don't care if this must be completely redesigned, no problem. Just don't know what to use for this.

I believe that's just about right. So I have the data in two columns B and C.

B has the days, Monday, Tuesdau, Wednesday, etc.

and C has the times 7:00 am, 1:40 am, 12:00 pm, 8:05 am, etc.

I highlighted both columns and then chose a pivot table. I used the days in the Row Labels and the times for values.

It gives me a count. Basically it counts all the times cars were seen on Monday - Sunday.

So yes for details. Is this where I can use the Report Filter now?
Wanting to see the chart reflecting which actual time of that day was the busiest for traffic. (example: You can see that between 11:00am and 5:00pm traffic was very busy.)