![]() ![]() I often make that conversion when working with groups with really large budgets (numbers in the millions, for instance).ĭoes your organization need to track how much money you’re making and spending? I see way too many Revenue and Expenses numbers gathering dust in hard-to-read pie charts. I made up the dollar amounts to anonymize their particular numbers but yes, displaying the numbers in thousands is a good idea. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |