Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

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.


Re: Probability Scale in Charting

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

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.


Re: Probability Scale in Charting

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.


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.