Excel Books

Books that I own and use while developing in Excel

Excel User Conference

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

 

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.