Peltier Technical Services, Inc.
- Custom Excel Solutions

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

PTS Utilities

Commercial Utilities developed by Peltier Technical Services

Waterfall Chart
Box and Whisker

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

Variable Width Column Charts

The following pages show how to make a more informative column chart, where the height of the columns indicates one value, and the width indicates another. The technique can also be applied to bar charts.

Stephen Bullen shows a dynamic range approach:
oaltd.co.uk/Excel/SBXLPage.asp#Charting, download FunChrt5.xls.

Andy Pope demonstrates a couple different approaches:
andypope.info/charts/colwidth.htm
andypope.info/charts/colwidth2.htm

I show how to make a variable width stacked column chart like the one below in my Matrix Chart article in Tech Trax e-zine.

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