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 →
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 →Nathan asks us Can You Improve this Mediocre Statistical Graphic? Since there are only two series (two parties) with a obvious mirror effect, I would say it doesn’t make sense (from a chart economy point of view) to display both series. And since the 50% mark is
Read more →I’d like to answer or comment on search queries that bring readers to my blog. Here are some of them involving pie charts: What is the usefulness of pie chart in research? Research found that many pie charts resemble Pac-man. Pie charts of the american revolution They
Read more →
Recent Comments