Chart previous week data as grouped and current week as ungrouped

Hello,

I want to show week wise data as a bar graph and it should also show some day wise data. How can it be done?
Case:

Everyday i check some cars and get a count of cars that are OK. I want to plot a weekly percentage of OK cars for previous weeks and for current week I want day wise OK% for current week. Can you please help me with this.

My efforts:

I have attached a sample data. "Data collection"sheet gives following data: Date | Day | Cars checked | No. of cars ok | ok%

Now in "Chart" sheet, i am able to group the dates week wise with corresponding weekly sum of cars checked and cars ok.

AIM:

Now following needs to be achieved:
1. I want the weekly OK % of cars plotted for previous weeks
2. For the ongoing week OK% should be plotted for each day.
3. "Expected output" sheet shows the expected output of the exercise.

If a vba needs to be written it will be fine.
Thanks in advance.