Trend Scatter Chart

Version

Application Scenario

The scatter chart is usually used to check whether the variables in the X axis and Y axis are in a certain relation.

The scatter chart has two value axes, namely the horizontal (X) value axis and vertical (Y) value axis. Combining the values in the X and Y value axes into individual data points, the scatter chart displays these data points with irregular intervals or in irregular clusters. The scatter chart is usually used to display and compare numerical data in fields such as science, statistics, and engineering. The scatter chart with trend lines can display the trend relationships among points more intuitively, as shown in the following figure.

Chart Feature

Advantage: The chart offers a clearer visualization of data trends.

Data Preparation

Choose File > New General Report in the upper left of the designer. Click xxx, click Database Query, and enter the SQL statement SELECT * FROM chance where province in ('Shanghai','Zhejiang Province','Fujian Province') to create a database query ds1, as shown in the following figure.

Chart Insertion

Merge required cells, click the Insert Chart icon on the upper toolbar, select Scatter Chart, and click OK, as shown in the following figure.

Scatter Chart Design

Select the chart, click the Cell Element icon on the right property panel, and set the attributes (Type, Data, Style, and Special Effect) for the chart.

Data Binding

Click Data and bind required data to the chart, as shown in the following figure.

Style Setting

1. Choose Style > Title and enter Yearly Production Per Province, as shown in the following figure.

2. Choose Style > Series and set Display in Line to Normal, as shown in the following figure.

3. Choose Style > Legend and set Position to Top, as shown in the following figure.

Effect Display

PC

Save the report and click Pagination Preview. The effect is the same as the that shown in section "Application Scenario."

Mobile Terminal

The report can be previewed on both the DataAnalyst app and the HTML5 terminal. The following figure shows the preview effect.

For details, you can download the template Trend Scatter Chart.cpt.