A reader wrote to point out a small oversight in last week’s introduction of the Excel Chart Cleaner tool.
Installed your chart fixer upper tool...and it seems to have been installed because it shows up checked in my add-ins list. But how do I actually USE it? If I have a sheet of data and make a line chart out of it...where is the button to press to clean it up with your add-in? Maybe I’m too much of a neophyte to be reading your blog and trying this stuff...but maybe you could let people know how to actually use this excellent tool you’ve provided instead of just installing it.
Thanks so much for putting this stuff out there. I learned more about Excel reading your blog than in several paid training sessions. Worth the price of getting out of bed today!
So, you’re one of those sneaky people that actually wants to USE the tool. Hmmm.
Well, here’s the secret: the add-in puts a menu item in the Format menu. If you have a chart already selected it will say "Clean this chart..." otherwise, it says, "Clean all charts...". Select the option and you’ll get a number of ways to clean and simplify the chart.
Thanks for the kind words. There’s a screencast coming on how and why to use the Chart Cleaner tool.