Archive for Dashboards
You are browsing the archives of Dashboards.
A line chart in Crystal Xcelsius: how difficult can it be?
Can Crystal Xcelsius replace Excel as a charting tool? As the regular readers know, I am creating an Xcelsius version of my Excel Demographic Dashboard to answer this simple question.
I am afraid the results until now are less than stellar. Although I could easily add four gauges with the four main demographic KPI, I am [...]
Is Crystal Xcelsius a toy piano?
Pascal Comelade, a french musician, plays toy pianos for a living. How many of us could do the same? How many of us could (professionally) use toys instead of our standard, grown-up tools?
Now imagine that a toy maker starts marketing their toys as serious musical instruments. How would Beethoven’s 5th Symphony sound like? At first, [...]
XCelsius Dashboard: the population pyramid
Can my Excel Demographic Dashboard be recreated in Crystal XCelsius? This is the main theme for this series of posts. In the first post I set the stage, define the rules and show how the basic “demographic KPI’s” can be displayed using gauges. The second post discusses one of the major drawbacks I find [...]
Sparklines, Excel, Crystal Xcelsius and stealth-mode charts
You struggle every single day to design the best, the most eye-catching chart for the next presentation. If your goal is to impress your boss, you can stop reading, I have nothing new to offer, I can’t even impress mine. But if you really want to understand your data, there is some (hopefully) interesting [...]
How to create a dashboard in Excel
Too often Excel is overlooked as a valid Business Information tool. Too often organization turn to expensive, proprietary BI solutions-that-become-problems after many months of expensive development. Too often the hidden agenda of some clueless IT dismiss Excel because of some stupid reasons. Excel is a powerful tool that can handle probably 80% of the business [...]
