I'm trying to create a bar chart with the width of each bar representing a
third variable. This is similar to the Bubble chart but using bars.

On Mon, 20 Aug 2007, in microsoft.public.excel.charting,
RAnd said:
I'm trying to create a bar chart with the width of each bar representing a
third variable. This is similar to the Bubble chart but using bars.

There is a way to do it if you cheat a bit. You can create an Area chart
with a Time-scale axis that follows a rectangular pattern, up, across,
down, across, and so on. Because the Time-scale axis lets you make
vertical lines, this works where the regular Area chart type, with a
category axis, would not. And because it's an Area chart, you can fill
the bars in, which you couldn't do if you did this using an XY scatter
chart type.

Try this out as a demo of the concept, and see if you can adapt it for
your needs:

http://www.branta.demon.co.uk/excel/DCVarBar.xls

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.