(…) On the top of the mountain was a plain. There stood an old stone house, and in front of the house lay a great fish-pond, but behind it was a dark forest. He saw neither men nor animals, everything was quiet; only the wind rustled among the trees, and
Read more →Data Visualization Blog
![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 →
We stop loving someone or something when we feel there is nothing more to discover, when we have no more questions, when we don’t care about the answers. I started writing my Data Visualization for Excel Users series because I have an unhealthy number of open questions.
Read more →
A new page for my tutorial Data Visualization for Excel Users is available. It’s about Gestalt laws. Don’t forget to leave a comment!
Read more →
Here is an interesting technique: using two y-axis to display the same data at different resolutions. Yellow (BMI) and blue (Weight) lines should overlap (there is a one-to-one correspondence between BMI and Weight for a given height), but they don’t because they are using a higher resolution
Read more →I like to call it the invisible data visualization: all those Excel charts made for private consumption by product managers, accountants, marketeers, sales reps. You can’t see them but they are there, and millions of hours are spent every single year making and presenting them. Then we have
Read more →
Data visualization is about finding and communicating patterns. But here is an often-forgotten truism: patterns are not some kind of ready-to-wear knowledge. You can look at a chart and have an epiphany and the person next to you can dismiss it as useless. Let’s see why. Is
Read more →
There are several objects in Excel you can make a map with. If you want to use shapes, you can follow 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 population
Read more →
Are you sure you can recognize an Excel chart from miles away? I thought that too. Then I started playing with some data visualization historical milestones and now I’m not so sure. Trying to recreate these charts in Excel is a great way to improve your Excel skills
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 →
Recent Comments