column chart

Add a chart that effectively compares the number of purchases on each of the six days.

Not very clear. How about posting a sample file and clear instructions on what you are trying to chart. Nobody can test a solution against a picture.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

I think the first step will be to compute a suitable summary of the data. A pivot table is my first guess: https://www.excel-easy.com/data-****...ot-tables.html
Once you have the data summarized, then insert your desired chart based on the summary of the data.