A new page is available in my tutorial “Data visualization for Excel Users”. It’s the first page of a mini series on how to make a chart and we’ll learn how to ask questions and what type of questions we should ask.
Read more →
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 →(…) 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 →![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 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 →
Recent Comments