Excel Dashboard Mood Tracker – Build an Interactive Log

Excel Dashboard Mood Tracker – Build an Interactive Log

An Excel Dashboard mood tracker helps you record feelings, spot patterns, and build healthier routines. With dropdowns, color rules, and a small chart, you’ll turn simple rows into a clear daily log that encourages reflection and steady progress.

Set up your mood log

• Create a table with columns: Date, Mood, Notes.
• Insert → Table to get structured references and easy formatting.
• Use TODAY() or DATE(2025,11,04) to fill dates quickly.

Add a dropdown for consistent entries

1. On a helper sheet, list moods (Happy, Calm, Anxious, Tired, Energized).
2. Select the Mood column → Data → Data Validation → List.
3. Point the Source to your mood list for clean, error-free input.

Color-code with Conditional Formatting

• Home → Conditional Formatting → New Rule.
• Apply rules like =$B2="Happy" to set a gentle green; pick distinct, readable colors.
• Keep contrast high for accessibility.

Chart your trend

1. Select the table and insert a Line or Column chart.
2. Group by week or month to reduce noise and highlight momentum.
3. Add a count of each mood with COUNTIF for quick summaries.

Pro tips for better self-tracking

• Log at the same time daily; short, honest notes beat long gaps.
• Protect formula cells to avoid accidental edits.
• Sync via OneDrive to update from phone or laptop on the go.

Where this fits in your stack

Embed the tracker inside an Excel Dashboard, explore ready-made Dashboard Templates, or mirror it in a browser-friendly Google Sheets Dashboard for easy sharing.

Keep learning

• 📺 Tutorials: Other Levels YouTube Channel

Other articles you might like

• Build Quiz or MCQ System in Microsoft Excel
• Efficiently Clean and Transform Data in Microsoft Excel
• Format Numbers and Dates Your Way with Microsoft Excel