Display sales data in an eye pleasing way

[TimClayton]

Hi all



I have extracted sales data into 2 columns as below:

[TABLE="width: 300"]
<colgroup><col style="mso-width-source:userset;mso-width-alt:4059;width:83pt" width="111"> <col style="mso-width-source:userset;mso-width-alt:2852;width:59pt" width="78"> </colgroup><tbody>[TR]
[TD="width: 111"]15/06/2019 12:55
[/TD]
[TD="width: 78"]£15.00
[/TD]
[/TR]
[TR]
[TD]15/06/2019 13:03
[/TD]
[TD]£105.00
[/TD]
[/TR]
[TR]
[TD]16/06/2019 10:56
[/TD]
[TD]£185.00
[/TD]
[/TR]
</tbody>[/TABLE]
etc. (about 800 sales over 6 months)

I'd like to display this data (can be several charts/tables) to show the following information:

1. Busiest day of the week (no. of sales)
2. Busiest day of the week (highest turnover)
3. Busiest time of day (no. of sales)
4. Busiest time of day (highest turnover)

There's probably several ways of doing this, but I'm looking for the one that's most visually pleasing/easy to read.

Just to clarify, I'd like the DAY of the week from the date, not the busiest dates. i.e. 12-1pm on Wednesday was the busiest day of week 1, 3-4pm on Tuesday of week 2 etc... Thursday is the busiest day of the week on average in the last 6 months...

Basically as much information as possible in an easy to read format.


Thanks in advance!