In this dashboard, the group wanted to see generally whether expenses were going up or down, and comparing Expense A to Expense B wasn’t a priority (because they knew payroll expenses would always be leaps and bounds above their electric bill, for example). In workshops I teach attendees both versions and we talk about the pros and cons of each approach. I purposefully made sparklines with relative vs. But you never know how different charts will do until you test them, so it’s worth a try for sure. In my experience, waterfalls take longer to understand at a glance than bar charts. I’ll share the waterfall versions and see what they think. I’m working with this group again in June for Day 3 of their workshop. (I created the charts with the Zebra BI Excel Add-in) A small multiple of (scaled!) line charts or hills&valleys charts could work better.įinally, can you display all numbers in thousands? That would result in slightly cleaner visualization. The sparklines in your dashboard show a wrong picture of quarterly trends, because they are not properly scaled. Next, for Q4 results, you can add the variance to Q3 like this: This solution shows both the STRUCTURE of revenues and expenses as well as their CONTRIBUTION to the company’s end results (profit/loss). I guess a VERTICAL WATERFALL CHART would better reveal the most important fact: what is the final result after you subtract the expenses from the revenue (Profit/Loss).
0 Comments
Leave a Reply. |