Your assumption is correct. However, I need to replicate a bar chart
using these probabilities.

For example, each event would have one bar. That bar would consist of
three shaded areas, each one reflecting a certain amount of sales that
would correspond to a % of probability. One bar might be a total
possibility of $4 million in sales, with a 25% chance of the $4
million, 50% chance at $2 million, and a 75% chance at $1 million.

Is there any way to do this?


--
SMCourbs
------------------------------------------------------------------------
SMCourbs's Profile: http://www.excelforum.com/member.php...o&userid=36772
View this thread: http://www.excelforum.com/showthread...hreadid=564864