Hello,

I want to make a horizontal bar chart (2-D bar in Excel 2007), in which the thickness of each bars is determined by the values in a cell.

I can't find any way to specify the thickness of these bars. I've seen Jon Peltier's guide to making a column chart with variable bar thickness here:

http://peltiertech.com/variable-width-column-charts/

This is similar to what I want, but I need a horizontal bar chart, and ideally there would be gaps between each bar.

Anybody have any ideas? I'm happy to use VBA, but don't know where to start...

Thanks