Capstone: A Dynamic Top-N Dashboard with a Chart
This lesson is part of the course
In this lesson
You build Lumen's Q4 top-N panel: one TAKE(SORT()) formula driven by N in E1, a share column, the top-N share of revenue and a bar chart of the leaders.
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
- Spill Basics: One Formula, Many Cells, and the #SPILL! Error Locked
- SORT & SORTBY: Largest First, Two Sort Keys and Custom Orders Locked
- FILTER: Criteria Cells, AND / OR Conditions and "If Empty" Locked
- UNIQUE: Distinct Lists, Distinct Counts and "Exactly Once" Locked
- SEQUENCE: Numbering, Date Series and a Monthly Calendar Locked
- Spill References (A1#): A Region Summary That Grows by Itself Locked
- Report Building: VSTACK, DROP, CHOOSECOLS, TAKE and HSTACK Locked
- Capstone: A Dynamic Top-N Dashboard with a Chart Locked