We have a dataset of marketing spending, Cost of Acquisitions and purchases of a company (the last column is added using IF() statement).

Line chart including 5 day average, scatter chart and the trend line are as following.

Now, a table is created to define if a day in the main table is weekday or weekend.

Based on this table, we can create a scatter chart with two categories of weekdays and weekends