INSYNTIVEAcademy
IDEN
Sign inSign up

Module 06 · PivotCharts from the Data Model

Chart 1: monthly trend, actual vs budget

Months on the axis, two measures in Values, then turn the budget into a line.

Step by step7 minLesson 25 of 37 Members

The trend chart is the most important chart on this dashboard, because it answers "what happened over the year?". You fill the empty PivotChart from the previous lesson with Bulan and two measures, then turn the budget into a line. It does not need to look neat yet; what matters is the right shape.

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
Become a member & unlock allAlready a member? Sign in

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