XY Scatter Chart in MS Excel
Update 2020-05-29
Formula for creating a transposed table out of linear time series data to plot multiple days with respect to time (x-axis) and count (y-axis) . . . (source)
{=INDEX(amount,MATCH(1,($F5=location)*(G$4=date),0))}
Here above amount is count, location is time and date is date. Create named ranges as used in the formula.
Check source link for more information.
Since this is an array formula it must be entered with control + shift + enter.
More references
XY Scatter over 24 hour timeframe
https://superuser.com/questions/541868/plot-date-and-time-of-an-occurrence
XY Scatter with multiple groups