Peltier Technical Services, Inc.
- Custom Excel Solutions

PTS Blog: Charts and Things

Jon's Excel and Charting Pages
- Jon's Charts - Tutorials - Excel
- Site Index and Search - RSS

Chart Types Not Native to Excel.

Microsoft Excel allows users to create many chart types, but people have invented many other chart types which at first glance are not possible in Excel. However, Excel's charting capabilities are extremely flexible. So with a little creativity, and with sometimes heroic formatting measures, it's possible to produce many of these chart types in Excel. Below is a partial list of charts which can in fact be made in Excel.

• Gantt Chart
• Step Chart
• Dot Plot
• Box and Whisker Chart
• Probability Chart
• Reciprocal Axis Chart
• Panel Chart: Stacked Chart With Vertical Separation
• Waterfall Chart (Bridge Chart)
• Matrix Chart (Marimekko Chart) (TechTrax Article)
• Clustered-Stacked Column Chart
• Control Chart (Run Chart) zipped workbook
• Run Chart with Mean and Standard Deviation Lines
• Tornado Chart (Funnel Chart)

Peltier Technical Services, Inc.
We can customize or automate any example from this site, or build a new one for you. To discuss your project or obtain a quote, please contact me at jonxlmvp@peltiertech.com

PTS Blog: Charts and Things

Jon's Excel and Charting Pages
- Jon's Charts - Tutorials - Excel - Site Index and Search - RSS

Peltier Technical Services, Inc., Copyright © 2008. 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