MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Probability Scale in Charting

Posted by Francis Cruz on June 06, 2000 1:21 AM

Hi! I'm a chemical engineer working in the plastics
industry. I use MS Excel in analyzing data from
mechanical testing.

One of the tests require plotting data on a scatter
diagram similar to Excel's XY Scatter chart type.
(For added info, if this would help a lot, the
chart type that I'm using is specified by ASTM -
American Society for Testing and Materials -
#D1693-97). I don't think that Excel has this
standard chart feature (unlike logarithmic scaling).
Do you know any add-ins that could do this if the
standard Excel features can't?

The ASTM standard mentions of a type of chart template
as "logarithmic probability graph paper," such as K&E
46 8082 or Codex 31, 376. The Y-axis is in
logarithmic form, while the X-axis is in the
probability format.

I hope someone can help me on this. Did anyone encounter this question before? Thanks in advance.

Posted by Jaime on June 06, 2000 10:25 AM


I think u have to pass ur x var to prob.
This is x would be the frequency distribution.
Maybe if i could see the chart i might figure how to do it in excel.

Posted by Francis Cruz on June 06, 2000 5:53 PM

Thanks Jaime. But I don't know how to show you the chart since I don't have an electronic copy (scanned image) of it. Anyway, if you encounter a K&E 46 8082 or Codex 31, 376 graphing paper, that would be it. Thanks again.