Adrian T -
Enter z values in column A, e.g., -4 through +4 in steps of 0.1 in cells
A2:A82.
Enter ln(z) in column B. E.g., in cell B2 enter =EXP(A2) and copy down to
B82.
Enter normal density f(z) in column C. E.g., in cell C2 enter
=NORMDIST(A2,0,1,FALSE) and copy down to C82.
Create an XY(Scatter) chart with ln(z) on the horizontal axis and normal
density f(z) on the vertical axis. E.g., Select B2:C82, click the Chart
Wizard button, choose XY(Scatter) as the chart type, etc.
Format the data series to show lines without markers and smoothed line. Use
more z values in smaller steps if necessary. Format axes to not show tick
marks and labels. Etc.
This method does assume "values are irrelevant," in that values on the
vertical axis are not actual lognormal density, but the values are
proportional to lognormal density, so the shape of the curve is accurate.
- Mike
www.mikemiddleton.com