Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007Back to Charting for Excel archive index
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
I hope someone can help me on this. Did anyone encounter this question before? Thanks in advance.
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.
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.