Hi everyone, can anyone lend insight to the below?

I will be mailing out checks every month for the next two years. I have
the exact payment schedule and the amounts for each corresponding
check.

Is there a way to create a chart in Excel so that when I open the file,
it recognizes the current date (or uses a form for date input) and
charts the total amount of payments made, tracked against the total
amount (e.g., in the "thermometer" style charts used for fund-raising,
etc.)?

Any help will be appreciated.
TIA!