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

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

Peltier Technical Services, Inc.

Excel Chart Add-Ins | Training | Charts and Tutorials | PTS Blog

Peltier Technical Services, Inc., Copyright © 2013. All rights reserved.
You may link to this article or portions of it on your site, but copying is prohibited without permission of Peltier Technical Services.

Microsoft Most Valuable Professional

My MVP Profile