(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 … Read more
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, … Read more
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. … Read more
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 … Read more
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 … Read more