Lognormal plot

By using the built in LOGNORM.DIST() or LOGNORMDIST() function: https://support.office.com/en-us/art...rs=en-US&ad=US

Use a range of values that straddles the area of interest ...

	A	B	C	D
1	mu	0
2	sigma	0.25
3
4	x	PDF	PDF
5	0.3	0.00005	0.00005	B5: =1 / (A5 * sigma * SQRT(2*PI())) * EXP(-((LN(A5) - mu)^2 / (2 * sigma ^2)))
6	0.4	0.00483	0.00483	C5: =LOGNORM.DIST(A5, mu, sigma, FALSE)
7	0.5	0.06835	0.06835
8	0.6	0.32977	0.32977
9	0.7	0.82390	0.82390
10	0.8	1.33931	1.33931
11	0.9	1.62241	1.62241
12	1.0	1.59577	1.59577
13	1.1	1.34901	1.34901
14	1.2	1.01929	1.01929
15	1.3	0.70773	0.70773
16	1.4	0.46078	0.46078
17	1.5	0.28555	0.28555
18	1.6	0.17035	0.17035
19	1.7	0.09869	0.09869
20	1.8	0.05589	0.05589
21	1.9	0.03111	0.03111
22	2.0	0.01709	0.01709

What do you mean by "it does not work"? Are you getting errors? wrong values?

I am not familiar enough with the lognormal distribution to know what typical values of x should be. I would expect you to pick reasonable values for x and evaluate the function at those values for x, then create a scatter chart based on those values:

Please Login or Register  to view this content.

Select A2:B100 and insert scatter chart.

What would you do if you needed a graph of sin(x)?

Not sure I understand the question.

By far (IMO) the easiest way to create any graph/chart in Excel is to:
1) Build a table of values like shg and I have both illustrated, then
2) Build a chart based on that table of values.

If your question is "Is there a way to build a chart without building the table first?", yes I'm sure it is possible. However, it is generally more difficult than building the table in the spreadsheet that I never use those techniques. I would have to have a very compelling reason not to build the table first.

See http://www.excel-easy.com/examples/scatter-chart.html for an example of how to insert a scatter chart.

Not sure we can help debug without something more to work with. What does the graph look like? What did you expect? What are the values in the table? Do the values plotted in the graph match the values in the table or not? Do the values in the table look correct?