Excel painting zhengtai Distribution

In this paper, there is a normal distribution chart, with only excel on hand. I chose an afternoon in Shanghai on the internet, changed N keywords, and finally found a tutorial, I tried the details myself. Today I want to find this webpage and paste the link here, but I cannot find it for more than an hour. It shows how coincidences I found it. No way. You can only repeat one word. Remember it here-in fact, I have forgotten it and can only try it again. The syntax of the normal distribution function is NORMDIST (x, mean, standard_dev, cumulative) cumulative, which is a logical value. If it is 0, it is a density function. If it is 1, it is a cumulative distribution function. If a normal distribution chart is drawn, the value is 0. For example, if the mean value is 10% and the standard value is 20%, first input A variable in A1. suppose-50, select column A, click Edit-fill-sequence, and select column, the same deviation sequence, with a step value of 10 and a termination value of 70. Then, type "NORMDIST (A1, 10, 20, 0)" in B1, And the return value is 0.000222. Select B1. When the mouse turns to a black cross in the lower right corner, drop down to B13 and select the A1B13 area, click the chart wizard-scatter chart on the toolbar, select the second chart in the first row, click Next, default settings, next step, write the title by yourself, deselect the check box in the gridline, and remove the check box in the legend, click Next to complete. The figure is initially completed. Below is the fine-tuning, right-click the mouse on the axis of the graph, select the axis format, and fill in the scale with the minimum value, maximum value, and main scale unit (numerical interval on the X axis ), the y axis is equal to (when y is 0, how much is x. After confirmation, the normal distribution chart is complete. PS: the syntax of the standard normal distribution is NORMSDIST (z), which is similar to that of the method. The original tutorial is to introduce how to draw a standard normal distribution.