You can’t write a novel just because you can type. You can’t create a chart just because you know how to do it in Excel. First, you have to know the job, then the tool. Research for best practices in your field. Read what some authors have to say about specific formats and options. Then, … Read more
How to create better charts? Search the web and you’ll find many specific advices, not always backed up by scientific evidence (can there be any?). Tufte’s advices are great for us, rational, positivist members of the human race, but what about those emotional poor fellows for whom a minimalistic chart is just a boring chart? … Read more
Scatterplots are not used by the NY Times because readers simply can’t make sense of them. Don’t oversimplify, but don’t assume that your audience can read a complex chart. Know your audience, and if possible test your charts with a small sample. Know what they expect, deliver that and perhaps a little more. When adding … Read more
Suppose you are sharing a list of orders with some co-workers. One of them wants to see the higher sales orders [fusion_builder_container hundred_percent=”yes” overflow=”visible”][fusion_builder_row][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][list]. Another one wants to know how much was exported to … Read more
A chart is just one of the available tools to communicate and help you and your audience to understand the data; sometimes using a chart is just plain wrong: if variation seems random or non-existent, what’s the point of displaying the data graphically (yes, I know, sometimes that’s what you want to show)? So, take … Read more
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 … Read more
We all know how found of pie charts Tufte is: A table is nearly always better than a dumb pie chart; the only worse design than a pie chart is several of them, for then the viewer is asked to compare quantities located in spatial disarray both within and between charts (…). Given their low … Read more
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 in … Read more
This chart [fusion_builder_container hundred_percent=”yes” overflow=”visible”][fusion_builder_row][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][via Junk Charts] in the New York Times uses a “tornado” chart (a population pyramid-like chart) to display two series, advertising spending in measured (traditional media) and unmeasured (Internet…) channels. … Read more
Al Gore and the U.N.’s Intergovernmental Panel on Climate Change won the 2007 Nobel Peace Prize. Why? Why Al Gore? Thousands of scientists have been warning about the climate change for years. Why not them? Because of his political weight? Of course, but not only that. Because he learned (the hard way) how to communicate … Read more