Excel Books

Books that I own and use while developing in Excel

Goods and Services

Excel or charting related products and services which I use or feel are worthwhile additions

Excel User Conference

2008 US East Coast Excel User Conference
September 24-27, 2008
Atlantic City, NJ

Charting in Microsoft Excel

Over the years I have learned a great deal about making charts in Microsoft Excel, and I have amassed a large collection of techniques for creating and formatting special charts. This is a categorized collection of my knowledge.

I've sorted the charts into the following topics. Many of the examples here fit into multiple topics.

Exhaustive Index of All Topics — What's New
Charting Tutorial — Chart Formatting
Background and Fill Effects — Chart Types Not Native to Excel
Combination Charts — Dynamic and Interactive Charts
Chart Axes and Axis Tricks — Dummy Series
Intro to Pivot Tables and Pivot Charts — Stock Charts
Charts for Statistics — Miscellaneous Charts and Topics
VBA Charting Techniques — Charting Utilities