Bar Graph (Waterfall) Chart

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

Hi
have a look at
http://www.tushar-mehta.com/excel/ch...fall/index.htm
http://peltiertech.com/Excel/Charts/...ies.html#Falls

--
Regards
Frank Kabel
Frankfurt, Germany

"Ricky" schrieb im Newsbeitrag
...
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

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


"Frank Kabel" wrote in message
...
Hi
have a look at
http://www.tushar-mehta.com/excel/ch...fall/index.htm
http://peltiertech.com/Excel/Charts/...ies.html#Falls

--
Regards
Frank Kabel
Frankfurt, Germany

"Ricky" schrieb im Newsbeitrag
...
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