Better Excel Charts Explained
By Chris Gemignani
May 1, 2006
Find more about:
excel
screencast
Here's a screencast showing the Excel Chart Cleaner tool being used.
Unlike previous screencasts, this one is not inline with the blog, but is on a separate page as I needed more elbow room to show the charting process.
The screencast is less than 5 minutes in length, so there is no real discussion of Excel charting problems. You can find those here or here. The video is safe for work.
This work is licensed under a
Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States License. All source code is released under a BSD License unless otherwise specified.






2 comments
Kelly O'Day said:
I have downloaded your Excel Chart Cleaner and am happily using it.
I really like your theme - let's improve what we have rather than criticize.
While Excel chart defaults look pretty ugly, effective Excel charts can look just as good as many custom, expensive packages.
We don't blame the hammer for ugly furniture, we blame the cabinet maker. A good piece of furniture, like a good chart, takes a skilled practicioner who uses good practices.
It's time to stop blaming Excel and to start helping users understand what it takes to make an effective chart. Your tool is a good start.
thanks!!!
..Kelly
koday@processtrends.com
Ben Johnson said:
I downloaded the chart cleaner and tried it on some line charts (which I've built as XY-scatters) that contain process data from a datalogging package.
Unfortunately, it doesn't do so well. The lines pick up solid fill underneath with all options checked. If I start unchecking options, the data series just end up disappearing. My data really is in good shape - it just needs the "chart junk" and "fix colors" options, but doing so leaves me with a blank plot area.
FWIW, I'm using excel 2000.
said:
Add a comment