Module 08 · Tell the story, maintain & fix

Arrange a dashboard that tells a story

Lay out the header, filters, KPI cards and four charts along a Z pattern, use colour sparingly, then add the finishing touches.

Step by step8 minLesson 34 of 37 Members

Every ingredient is ready: four charts, KPI cards, slicers and a timeline. What separates an ordinary dashboard from one that makes your manager ask "who built this?" is the arrangement. A reader gives it about ten seconds, so the dashboard must answer three questions in order: how are we doing overall, what happened over time, and then who and why. In this lesson you arrange everything along a Z pattern, use colour only where it matters, and add the finishing touches.

Members only

Continue this course with a membership

Modules 1–2 of the Excel course are free. This lesson and 27 more are open to active members.

  • 5 steps with a numbered picture
  • All 37 Excel lessons, plus the Power BI, Tableau & Data Viz courses
  • A new Excel & dashboard template every day, with resell rights
  • Take paid client projects on the Project Board

One payment for 12 months, no automatic renewal. Back to the free lessons