Excel Monthly Habit Tracker Dashboard

I’m looking to centralise all of my monthly habits in a single Excel workbook that feels more like a dashboard than a spreadsheet. For every habit I want two core data points: a simple Yes/No to confirm the habit was completed during the month and the total time I spent on it. As the data builds, I’d like automatic visual feedback—clean charts, clear graphs and intuitive progress bars that refresh themselves whenever I enter or modify a value.

The file should be easy to expand; I’ll probably add and archive habits over time, so formulas, tables or pivot-based solutions that scale without much manual tinkering are essential. A polished, at-a-glance dashboard (think conditional formatting, percentage rings or bar visuals) that rolls up performance for the current month and lets me compare previous months would be perfect.

Deliverables:
• Fully-functional .xlsx habit tracker with integrated charts, graphs and progress bars
• Auto-updating dashboard summarising monthly completion status and total time spent
• Brief, step-by-step notes showing how to add new habits or extend the date range

No need for macros if the same outcome can be achieved with formulas, but I’m open to VBA if it keeps the workflow slick.