Module 06 · PivotCharts from the Data Model

Charts 2 & 3: departments and categories

Two horizontal bar charts: actual vs budget per department, and cost categories sorted from largest.

Step by step7 minLesson 26 of 37 Members

After the trend, readers want to know "who spends the money, and on what?". You build two horizontal bar charts the same way as the trend chart: one per department (actual vs budget) and one per cost category. The category chart is then sorted so the largest sits at the top.

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 all Already a member? Sign in

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