The Trend Chart: This Year vs Last Year
This lesson is part of the course
In this lesson
You calculate the monthly growth and draw the dashboard's main chart: two lines, 2026 against 2025, with both axes titled.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Plan the Dashboard: Questions, KPIs & Layout Locked
- KPI Cards with Green/Red Rules Locked
- The Trend Chart: This Year vs Last Year Locked
- Category Breakdown: A Sorted Bar Chart with Labels Locked
- Sparklines: A Trend in Every Region Row Locked
- Target vs Actual: Combo Charts & the Secondary Axis Locked
- A Month Picker: INDEX/MATCH & SUMIFS-Driven KPIs Locked
- Final Project: The One-Page Sales Report Locked