Excelcharts - excelcharts.com - The Excel Charts Blog
General Information:
Latest News:
Excel dashboard: Using Excel for catchment area analysis 20 Jun 2013 | 05:37 pm
I’m sure you’re familiar with the Walmart growth map. A basic visualization looks like this: Obviously this has a lot of potential for a more design-oriented approach, and there are many examples onl...
Strange L-shaped trends 14 May 2013 | 04:26 am
There is not much of a story in the expected evolution of US population, according to the United Nations estimates and projections (1950-2100): (You’ll see in a moment why there is a vertical line in ...
Strange L-shaped trends 14 May 2013 | 04:26 am
There is not much of a story in the expected evolution of US population, according to the United Nations estimates and projections (1950-2100): (You’ll see in a moment why there is a vertical line in ...
Making Excel maps without VBA 6 May 2013 | 08:11 pm
If you want to make a choropleth/thematic map in Excel without programming perhaps conditional formatting is all you need. Here is how to do it: Select a few hundred columns and rows; Set width and he...
Making Excel maps without VBA 6 May 2013 | 08:11 pm
If you want to make a choropleth/thematic map in Excel without programming perhaps conditional formatting is all you need. Here is how to do it: Select a few hundred columns and rows; Set width and he...
Finally revealed: the optimal number of categories in a pie chart 14 Feb 2013 | 09:52 pm
It’s very simple, really: you do not compare proportions in a pie chart. Because a pie chart is not a comparison chart, it’s a part-to-whole chart. When you do this: what you really want to do is to c...
Finally revealed: the optimal number of categories in a pie chart 14 Feb 2013 | 09:52 pm
It’s very simple, really: you do not compare proportions in a pie chart. Because a pie chart is not a comparison chart, it’s a part-to-whole chart. When you do this: what you really want to do is to c...
Chart: Education vs. GDP in Europe 8 Jan 2013 | 09:39 pm
(click to enlarge) I have a single and very simple resolution for 2013: make more charts. Simple charts, just to play with the data. Here is the first one. I like scatter plots with a time dimension, ...
Chart: Education vs. GDP in Europe 8 Jan 2013 | 09:39 pm
(click to enlarge) I have a single and very simple resolution for 2013: make more charts. Simple charts, just to play with the data. Here is the first one. I like scatter plots with a time dimension, ...
Context comes in many ways and shapes 2 Jan 2013 | 05:56 pm
We (datavis folks) like to believe that one of the key advantages of charts over tables is that charts are much better at providing context, displaying patterns and so on, while a tables “merely” give...
