I. Description
The normal distribution plot is realized by a combination chart. The effect as shown below:
II. Example
2.1 Prepare Data
Please adjust the three data of normal distribution graph: Group, Frequency, and Normal Distribution Curve according to your application scenarios.
For the calculation process of the normal distribution graph data in the example, see
Create a new workbook and add a built-in dataset, as shown in the figure below:
2.2 Insert Chart
Click Insert Chart>Combination Chart>Column-Line Chart, as shown in the figure below:
2.3 Data Settings
Select the chart, and the column chart and line chart data settings are as shown in the figure below:
2.4 Style Setting
The style needs to be noted that the shape of the line graph should be set to a curve, as shown in the following figure:
2.5 Save and Preview
Save the template, click Pagination Preview, the effect is as shown in the description.
The mobile terminal preview is shown in the figure below: