This may be extremely simple...

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!

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
>
>

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
>
>

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
>
>

Thanks for the reply. I have entered the following in my sheet:

A2, 3, and 4 have the events : "HOTEL", "BID" and "NEW PRODUCT".
B2, 3, and 4 have the amount of business in dollars: $4 million, $1.1 million, and $1.2 million
C2, 3, and 4 have the probabilities: 70%, 80%, and 75%

Which line graph should I be using? I was trying to show the info in a bar graph initially. Should I have the info entered differently?

Thanks for any specifics.

I was of the impression that you had more data to plot, like Hotel has a 70%
chance to make 4 million and a 30% chance to make 6 million. If this is the
case, use a line chart.

If it's just the 3 points you have here a it would be tough to find a way to
plot it that makes sense to read. Let me know if my assumption was correct
and we can go from there.

"SMCourbs" wrote:

>
> Thanks for the reply. I have entered the following in my sheet:
>
> A2, 3, and 4 have the events : "HOTEL", "BID" and "NEW PRODUCT".
> B2, 3, and 4 have the amount of business in dollars: $4 million, $1.1
> million, and $1.2 million
> C2, 3, and 4 have the probabilities: 70%, 80%, and 75%
>
> Which line graph should I be using? I was trying to show the info in a
> bar graph initially. Should I have the info entered differently?
>
> Thanks for any specifics.
>
>
> --
> SMCourbs
> ------------------------------------------------------------------------
> SMCourbs's Profile: http://www.excelforum.com/member.php...o&userid=36772
> View this thread: http://www.excelforum.com/showthread...hreadid=564864
>
>

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?

Can't you calculate your sales for each probability level, so some
subtraction, and produce a stacked bar or column chart?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"SMCourbs" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>