Abstract:

You can do a lot with Excel charts. But sometimes you need a feature, such as a particular label, or a target line or range, & you just can't find it in Excel's many commands & formatting tools. And despite the wide range of chart types available, there's always the one you need that Excel doesn't offer.

I'll show how you can commandeer regular Excel chart elements, plus custom formatting & data layouts, to add features to charts & even chart types that Excel doesn't ordinarily make available.

Bio:

Jon Peltier was trained as a research scientist, & learned to make charts for his doctoral research using a pen plotter driven by BASIC. During two decades as a research & production metallurgist, he became skilled at Microsoft Excel, & became an Excel MVP (Most Valuable Professional) in 2001. Jon started Peltier Technical Services in 2004. His many activities include contract programming, training, blogging, conference appearances, & popular commercial Excel add-ins.