Creating a pair of dynamic graphs for a dashboard presentation

I need to create a pair of donut graphs that detect what week the current day/date falls under.  Simply put, we are tracking how many lots/work orders pass final inspection and how many get rejected.  This needs to be in a rather simple dashboard style presentation for our Monday Manager's Meeting (MMM) every week.

I thought I was going to be able to attach my file but I don't see a button to do that.  I'll insert a picture.  I want the "PREVIOUS WEEK" graph on the left to detect the current date when they open the file at the MMM, and automatically plot/display the pass/reject info for the previous week.  I want the "YEAR-TO-DATE" graph on the right to simply display that: the year-to-date.  Obviously, we're not very far into 2022 just yet, but there should be enough there to see what I'm getting at.  The formulas/data reference other worksheets, but this is simply a graph question, which is restricted to the sheet in the picture.