Overview
Expected Effect
When creating statistical charts in FineReport, you want to create a normal distribution chart. The following figure shows the expected effect.
Implementation Method
Prepare the pre-calculated data first and use Column Chart-Line Chart to create a normal distribution chart.
Example
Data Preparation
Adjust the data of Group, Frequency, and Normal Distribution Curve for the normal distribution chart according to your application scenarios.
For details about the data calculation process of the normal distribution chart, see Normal Distribution Chart.xlsx
Create a general report and create a built-in dataset, as shown in the following figure.
Chart Insertion
Merge required cells, click the Insert Chart icon, and choose Combination Chart > Column Chart-Line Chart, as shown in the following figure.
Data Setting
Select the chart, choose Cell Element > Data, and set the data for the column chart and line chart respectively, as shown in the following figure.
Style Setting
1. Set Series Gap and Category Gap to 0 to ensure no gaps among columns in the normal distribution chart.
2. Set the line style of the line chart to Curve and Type of the mark point to None, as shown in the following figure. You can modify other settings as needed.
Save and Preview
1. PC
Save the report and click Pagination Preview. The effect is the same as in section "Expected Effect."
2. Mobile Terminal
The report can be previewed on both the DataAnalyst app and the HTML5 terminal. The following figure shows the effect.
Template Download
The completed template can be found in: %FR_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\Chart\Combination\Normal Distribution Chart.cpt
You can download the example template: Normal Distribution Chart.cpt