Need Help Building a Dashboard

Attached is a file containing Sample Data in Table Format. I am looking to build charts on a Dashboard to display the following:

1. "Previous Day Output" vs. "Daily Target": Display Actual, Target and % of Target Achieved
2. "Current Week to Date Total Output" vs. "Weekly Target": Display Actual, Target and % of Target Achieved
3. "Current Month to Date Total Output" vs. "Monthly Target" : Display Actual Target and % of Target Achieved

Week is Sunday - Saturday

The data table will be updated daily and displayed on monitor in our plant. Would need to display data based on Current Day, Week and Month.

Any help would be greatly appreciated. I know how to build charts but do not know how to make them interactive do update as described above.

In the top menu bar (lighter blue) you will see a Dashboard button, and if you click on this you will see the 3 winners of a Dashboard Competition held on this forum a few years ago, and you can also view some of the other contributions made at that time.

Perhaps they will give you some ideas.

Hope this helps.

Pete