View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Caerus
 
Posts: n/a
Default Probability Graph - help please

Have you tried using the data analysis component of Excel? If not, I would
add that in and put inyour data. Once done you can run any type of
probability analysis you want and then select from the graph options within
the analysis.

"Luke Williams" wrote:

Hello,

I am trying to create a probability graph. On the x-axis, I would like to
have days (365 days). The Y-axis would represent a volume of liquid (from
0.4 to 32.0L). This water is shipped to a location every 6 days. The water
comes either in 0.4 L, 23.5 L or 32.0 L per shipment. How would you
construct a graph that would visually show this knowing also that you can
only have two consecutive shipments of the same quantity (ie. Shipment 1=0.4,
shipment 2=0.4 but shipment 3 could not equal 0.4).

Thanks so much for your help