Use one line chart chart where the series is Events, X-axis is amount of
business and the Y-Axis is the probability. Let me know if you need
additional help.

"SMCourbs" wrote:


This may be really simple, but here is my situation, and what I am
trying to accomplish:

I'm trying to create a chart that will show the probability of landing
a certain amount of business due to several events (let's call the
events "New Product," "Bid Work," and "Hotels").

For example, I would like the chart to show a 70% probability of the
"New Product" event creating $1 million of new business, and possibly
an 80% of the "Hotels" event creating $1.1 million, and a 75% of the
"Bid Work" event creating $4 million. This could be done either via
three separate charts, or one cumulative chart.

What is the easiest way to accomplish this? I can provide more info if
needed.

Thanks!


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