(All the Excel charts in my book are available for download, but I promised to write tutorials for a few of them. This is the first one.) Name: Bullet charts What it is used for: to display key performance indicators. Use them to replace speedometers if you want a more compact visual that can be stacked to better compare KPI. Also, speedometers [...]
[Update: I wrote a tutorial on how to make bullet charts] I am sure I'm missing something here, but I don't understand why making bullet charts and boxplots have to be so overly complex in Excel. Instead of messing around with bars and scales and secondary axes, a 1D scatterplot can be used to make both charts. I've been using [...]
A year ago I wrote a post about the circumplex chart and how consulting firms use charts to increase their price tag. Not all charts, mind: only the ones that the average user don't recognize from the Excel charts library. Funny enough, I got several messages from consultants asking how that chart was done. So, in the spirit of the [...]
OK, I'm very please to announce that ExcelCharts.com members area is now open and a new online Excel 2007 dashboard tutorial is available. Go ahead an open a free account: the first two modules are available there and more free stuff is coming soon. As promised, current users will get free access to this course. Know more about the dashboard [...]
Animated charts are overrated. If you are using Excel, try to design a better user experience through interaction, not animation.
You need a better color palette for your Excel charts, but you are a mere mortal and your artistic skills are less than stellar. Hell, you can't even choose the right tie for a suit! So, what do you do? (hint: watch the video below) Maybe we could ask Edward Tufte for advice. In Envisioning Information, he writes: What palette [...]
Screencast: How to create a population pyramid in Excel. I am a big fan of screencasts, as a regular reader of this blog may have already noticed. They are great at showing how to use a tool to get something done and they are the best companions for tutorial (e-)books. This hypotetical regular reader might also guess from my previous [...]