Scatter Chart by Group

Version

Application Scenario

The scatter chart by group displays the distribution of two variables of a single series or multiple series. You can make a scatter chart by group using the scatter chart, as shown in the following figure.

Chart Feature

Advantage: The chart intuitively displays data distribution.

Disadvantage: The chart is unsuitable for displaying large datasets. You may find it hard to distinguish the distribution when too many data points cluster together.

Data Preparation

1. Sample data: Experimental Sample Data.xlsx

2. Choose File > New General Report in the upper left corner of the designer and add an Excel dataset, as shown in the following figure. 、

Click OK. You can view the added Excel dataset in the Template Dataset area, 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 properties (Type, Data, Style, and Special Effect) for the chart.

Data Binding

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

Style Setting

1. Choose Style > Title, enter Experimental Sample Data, and set the font size to 10 in Character, as shown in the following figure.

2. Choose Style > Legend and deselect Show Legend, as shown in the following figure.

3. Choose Style > Series.

Color: Set Color Scheme to Custom Combination, or modify the colors as needed. Set Opacity to 65%.

Mark Point: Set Point Style to General and Type to •.

4. Choose Style > Axis.

Label: Set the font size to 8 in Character for both X Axis and Y Axis.

5. Choose Special Effect > Interaction.

Deselect all setting items in Content and Label.

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 Scatter Chart by Group.cpt.