Day of the Week vs Time of the Day

[Spar]

So I'm trying to analyze customer behavior in response to an email marketing campaign to medical professionals. I have the following data:

Date of campaign launch (date and time of the day)
Date and time of the message opened by the targets (of the campaign)

I'm having a really hard time trying to graph Time of the day against days of the week. The scatter isn't coming out right at all, instead of displaying days of the week on the X-axis, it's displaying numbers.

Can anyone help me? I've attached the dataset, all sensitive data has been purged.

[Andy Pope]

Is this what you was expecting?

xy-scatter only plots numbers. For an axis with categorical labeling you would need a line chart, which is not suitable.
Instead you can make you own axis labels with a dummy series.

You need to convert the time in to a value between 0 and 1 for hours in the day. And day needs to be converted to a value between 1 and 7.

[Spar]

Thanks, this is what I was looking for!