Target vs Actual: Combo Charts & the Secondary Axis
This lesson is part of the course
In this lesson
You calculate % of target per month and build the two classic target charts: actual columns with a target line, and actual with % of target on a secondary axis.
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