The best chart is always task-dependent, but let me assume that you would choose the scatterplot as the best chart and the pie as the worst. They are like water and oil: impossible to mix them! Are they? Let me tell you about a little experiment. I
Read more →![The Unbearable Lightness of Pie Charts [Data Visualization for Excel Users]](http://www.excelcharts.com/blog/wp-content/themes/u-design/scripts/timthumb.php?src=http://www.excelcharts.com/blog/wp-content/uploads/2011/12/pie-chart-clices-chunks.png&w=570&h=172&zc=1&q=90)
Well, a data visualization book cannot avoid pie charts, so here it is, a page about pie charts for my tutorial Data Visualization for Excel Users. Enjoy and comment, please…
Read more →
There are several objects in Excel you can make a map with. If you want to use shapes, you can follow my my tutorial. You can also use a scatter plot. The map above uses cells and conditional formatting. So, here is how to do it (this example used
Read more →
Choropleth maps are the pie charts of cartography. Both can show us a simple pattern, but that’s a very low starting point. And both have severe perceptual issues. One of the issues with maps is how to define classes. Gregor published last Friday an interesting post and I wanted
Read more →
I recently bought a pedometer to make sure I walk at least those recommended 10,000 steps a day. As you can see, there is a strong variation, and no meaningful pattern is emerging. Now that I’m blogging about it, I’m sure that will happen soon . It’s
Read more →If you are a market researcher, and you want to make sure that you get more reliable results for a subgroup in a survey, what do you do? You must increase the overall sample size (and spend a lot of money), right? Actually, you don’t. You can
Read more →In what seems to be a post-vacation syndrome, I am in the mood for pie charts. I see them everywhere, even in car logos. Actually, I am more in the mood to defy current “crowd wisdom” about pie chats. Search the web for “pie chart” and you’ll
Read more →Best Pie Chart Award (clean and balanced. Your perception may not be great at comparing angles, but who cares?) 2th Place (also nice, but too many slices, and I don’t like the title around the pie) Lateral Pie-Thinking Award (well, perhaps someone just messed up
Read more →I’m a consensus kind of guy, I can’t help it. I always try to find the best parts of not-so-good things (a Curate’s egg syndrome?). Let me give you an example. One of the reasons why people like pie charts is because of its strong and familiar
Read more →
Recent Comments