Sorted Bars & Top 5 + Other: Rank With Formulas
This lesson is part of the course
In this lesson
You rank twelve product categories with LARGE and INDEX/MATCH, fold the long tail into an "Other" bar and chart a readable Top 5.
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
- Start With the Message: Pick the Right Chart Locked
- Declutter: Drop the Legend, Label the Bars Directly Locked
- Highlight One Series: Colour With Purpose Locked
- Sorted Bars & Top 5 + Other: Rank With Formulas Locked
- Before and After: The Two-Point Slope Chart Locked
- Showing Change: Waterfall vs Stacked Columns Locked
- Honest Axes: Bars Start at Zero Locked
- Write the Headline: State the Insight With the Number Locked