Bar Graph (Waterfall) Chart

[Ricky]

Hello,
Profits in $ are shown in the Y axis (left hand side)
The bar chart will go up or down based on the Profit $ amounts.
Products A, B, C etc. are on the X axis.
The third item to be shown in chart are Volumn in units. How do I make the
each of the bars widen according to the number of units?

This type of chart has been named "waterfall" chart, but I couldn't get the
Chart Wizard to come up with anything similar to it.

Thanks in advance,
Ricky

 

[Frank Kabel]

Hi
have a look at
http://www.tushar-mehta.com/excel/charts/waterfall/index.htm
http://peltiertech.com/Excel/Charts/DummySeries.html#Falls

 

[Ricky]

Hi Frank,
Thanks for the links. I've gone through both sites and have found some
helpful information about waterfall charts. However, I still can't get the
bars to widen based on a 3rd criteria. I could get the bars to show the
profit $ on the Y axis, the Products on the X axis...I just can't get the
3rd part (Units) to be represented by width of each bar.

Thanks again,
Ricky