Make a statistical chart

Instructions for use

The SuperMap desktop supports the creation of statistical charts for attribute tables and Vector Dataset. The supported Chart types include 11 types of statistical charts: histogram, bar chart, pie chart, line chart, bubble chart, area chart, combination chart, scatter chart, sequence chart and histogram.

Function entrance

  • Method 1: Open Datasource in Workspace Manager, click the Statistical Chart Drop-down Button in the Browse group on the Start tab, and select the Chart Type to be created.
  • Method 2: In Workspace Manager, select the Dataset for which a statistical chart is to be made, right click Add to Statistical Chart, and select the Chart Type to be made.

Operating instructions

To create a Diagram, you need to go through the following steps:

Step 1: Create the chart

Select Chart Type to create a Diagram, and the corresponding statistical chart schematic diagram window and statistical chart Property Settings panel will pop up by any of the above methods. Prompt the user to set Statistic Field, Group Field and other parameters in the Statistical Chart Properties Panel to complete the creation of the Diagram.

Step 2: DiagramParameter Settings

The Parameters of the Properties Panel are slightly different depending on the type of Diagram selected. The parameters of the Properties Panel for the histogram, bar chart, line chart, and bubble chart are the same, while the parameters of the pie chart, area chart, and time sequence chart are one or two fewer than those of the histogram. The panel parameters of ring chart, combination chart, scatter chart and histogram are different. The parameters of Diagram are divided into general parameters and specific parameters for separate introduction.

General Parameter Settings

  • Data Settings: Select the Statistical Data set and the Datasource where it is located.
  • Filter: Set the Dataset display filter by building an expression for SQL Query. Refer to the Build expressions for SQL Query for Filter settings.
  • Color Scheme: The color scheme is provided for the color rendering of statistical sub-items, and a rendering color is reasonably allocated to each sub-item according to the number of statistical sub-items. SuperMap classifies Color Schemes according to Diagrams Type and where applicable. It is divided into categories such as For DEM, Aggregate Graph, For Statistical Thematic Map, For Unique-Values Map, etc. Meanwhile, Color Scheme supports User Custom. The user can select the corresponding Color Scheme according to the drawing requirements. For the detailed introduction and operation of Color Scheme, please refer to Color Scheme Manager.
  • Display Legend: Display Legend can be controlled by checking the checkbox. Double-click the legend to modify the legend style.

Bar, Bar, Line, Bubble, Pie, Area, Time Series

The parameters of column chart, bar chart, line chart and bubble chart are consistent, the parameters of Sorting Field and Show AvgLine in sorting group are absent in pie chart, the parameters of Field 2 in Group Field group are absent in area chart, and the parameters of Sorting Field and Sorting Type in sorting group are absent in time sequence chart.

Parameter Description is as follows:

  • Statistic Field: Select a Property Field in the Dataset as the Statistic Field of the statistical chart, which is generally displayed along the Y axis. Support the statistics of multiple Property Fields, that is, add multiple Statistic Fields. For example, when the user needs to perform Statistic Analysis on the data of multiple years, the fields of the years to be counted are all used as Statistic Fields.
  • Aggregation Type: It is used to calculate the value of Statistic Field. The program provides 6 aggregation types, including Count of Single Values, Sum, Average, Median, Variance, and Standard Deviation. The user can select a specific aggregation type according to the statistical requirements.
    • Count of Single Values: When the aggregate type is Count of Single Values, The value of the Statistic Field is the Count of Single Values for the Group Field value.
    • Summation: When the aggregation type is summation, the value of Statistic Field is the sum of the selected attribute values in Group Field.
    • Average: When the aggregation type is Average, the value of Statistic Field is the average value of the attribute value of the selected Group Field.
    • Median: When the aggregation type is Median, the value of Statistic Field is the median of the attribute value of the selected Statistic Field.
    • Variance: When the aggregation type is Variance, the value of Statistic Field is the variance of the attribute value of the selected Statistic Field.
    • Standard Deviation: When the aggregation type is Standard Deviation, the value of Statistic Field is the standard deviation of the attribute value of the selected Statistic Field.
  • Group Field: Select a Property Field in the Dataset as the Group Field of the statistical chart, which is generally displayed along the X axis. Two Group Fields can be set. Field 2 is a secondary grouping based on Field 1. Secondary grouping only supports one Statistic Field. When the set number of Statistic Fields is greater than 2, secondary grouping is not supported. For example, in the GDP histogram of each province in China in 2019, Statistic Field is the GDP output value in 2019, Group Field 1 is the name of each province, and Statistic Field2 is the area classification field. Note: Group Field 1 in the sequence diagram must be Date Type.
  • Sort: It is used to control the X-axis Display Order, that is, to display the X-axis Display Order of the chart through the sort field and sort type. There are two types of sorting: ascending and descending.
  • Group and Statistics Field Replacement: Select the check box to replace Statistic Field and Label Field in the figure. After replacement, the original Statistic Field Y axis will be displayed as the X axis, and the original Label Field X axis will be displayed as the Y axis.
  • Show AvgLine: Select this check box to show the average value of Statistic Field in the form of a straight line in the statistical chart. If there are multiple statistical sub-items in the statistical chart, each statistical sub-item will calculate its own average value and display in the chart.

Example: Take the production of Beijing air quality line chart as an example, to count the AQI index of 2014, 2015 and 2016, set the month as Label Field, add the AQI of the three years as a statistical sub-item, aggregate the type according to the summation method, and finally get the statistical chart as shown in the following figure.

Figure: Statistical Chart Parameter Settings and Result

Combination diagram:

  • Group Field: refers to the field attribute displaying the X axis information in the combination chart.
  • Statistic Field: a combination chart is a combination chart formed by combining two charts. Two Statistic Fields need to be set, including Y-axis 1 and Y-axis 2. Click the Drop-down Button on the right side of Statistical Method to set Statistic Fields of Y-axis 1 and Y-axis 2.
  • Display Method: The Display Method supports the selection of four types of charts: histogram, pie chart, line chart and scatter chart. You can select two of the same type or different types freely.

Example: Take the combination chart of the relationship between GDP and population of all provinces in China in 2014 as an example, set GDP _ 2014 as Statistic Field Y axis 1, and Display Method as a bar chart; Populations Pop _ 2014 is set as Statistic Field Y-axis 2, and Display Method is scatter chart; the final result is the statistical chart as shown in the figure below. of Combination Chart

Figure: Parameter Settings and Results

Histogram

  • X Axis Field: used to set the X axis of the statistical chart. This field is used as the Group Field of the histogram.
  • Number of segments: Group the X axis fields of the set value, and enter the specific segment value in the text box. The height of the histogram is the number of frequencies that fall within the number of segments.
  • Number of Decimal Places: Set the display format of X-axis data in the histogram.
  • X-axis Display Mode: Provide left and right Display Modes, i.e. display the left or right range of Range Interval.

Example: Take the histogram of the frequency of the math score of a class as an example, set the math score as the X-axis field and the number of segments as 6, and finally get the statistical chart as shown in the following figure.

Figure: Histogram Parameter Settings and Result

Scatter Chart

  • X-axis/Y-axis field: Scatter chart plots the position of scatter points using data values as X, y coordinates. The X-axis/Y-axis field is a numeric field.
  • Group Field: Group Field is the field attribute represented by the scatter.
  • Display Linear Regression: The linear regression line is a linear regression fitting line obtained by modeling the relationship between one or more independent variables and dependent variables through the least square function of the linear regression equation for the two variables X and Y.

Example: Take making the scatter chart of national urban income and expenditure as an example, set the income as the X-axis field, the expenditure as the Y-axis field, and the province name as the Group Field, and finally get the statistical chart as shown in the following figure.

Figure: Scatter Plot Parameter Settings and Result

doughnut

  • Statistic Field: Select a Property Field in the Dataset as the Statistic Field of the statistical chart.
  • Group Field: Set a Group Field to be a donut. Support setting multiple Group Fields to generate multiple donut charts nested together. You can adjust the sub-item order of the Group Field and set the nesting order of the rings. By default, the first Group Field is the innermost ring, and the rings are nested outward in turn. As shown in the figure below, the Group Field in the inner ring is set as the GDP (Region) of each of the seven regions in the country, and the Group Field in the outer ring is set as the GDP (Name Field) of each province.
  • Sort Type: Used to set the Display Effects of the ring and sort it according to the numerical value in the Group Field. Both ascending and descending types are supported.
  • Inner Ring Ratio: set the proportion of inner ring.
  • Inner Ring Color: Set the color effect of the inner ring.
Figure: Scatter Plot Parameter Settings and Result

Step 3: Style Settings

  • Display Method: Support switching between different types of statistical charts. For example, column chart, pie chart, line chart, bubble chart and bar chart can be switched to each other.
  • Background Style: The program pre-defines a variety of statistical chart background styles for the user to select. You can select the appropriate background style by clicking the label control Drop-down Button.
  • Title Settings: Support Modify Diagram title and set Title Font type and Font Size.
  • X/Y Axis Settings: Support the title name of X axis and Y axis of Modify Diagram, and set its font type and size.
  • Custom Extreme Value: Support setting the maximum/minimum extreme value displayed on the coordinate statistical axis, and control the Visible Bounds of the statistical coordinate axis, so that the chart can better represent the Valid Range of data changes.

Doughnut Style Settings

  • As Percent: if this check box is checked, the Statistical Method is the percentage of each Statistic Field in the overall total; If the check box is not checked, the Statistical Method is the value of the Statistic Field.
  • Show Lable: Set whether to display the Statistics Result label in the doughnut chart.
  • Label Position: Set the position where the Statistics Result label is displayed in the doughnut chart. The program provides five display positions: inside the chart, outside the icon, Two Columns, Radial and Tangent.

Step 4: Diagram Processing

Modify Diagram: On the Chart tab, in the Diagram Processing group, click the Modify Diagram button to bring up the Chart Parameter panel. You can also modify the Diagram

parameters by selecting the Modify Diagram option in the Diagram Window Context Menu.

Save Chart: There are two ways to save a chart:

  • Method 1: On the Chart tab, in the Diagram Processing group, click the Save button to bring up the Save Chart dialog. Enter the name of the diagram in the dialog box, and then click the OK button.
  • Method 2: Right click the mouse in the current statistical chart window, select the Save command in the pop-up Context Menu, pop up the Save Statistical Chart dialog box, enter the name of the chart in the dialog box, and then click the OK button.
    • After the
  • chart is saved, a new chart node will be added under the statistical chart set node in Workspace Manager. This node corresponds to the chart just saved.
  • If the current chart is an existing chart in Workspace, the modification to the chart will be saved to the current statistical chart.

Export as Image: There are two

ways to Export as Image:
  • Method 1: In the Diagram Processing group on the Statistical Chart tab, click the Export as Image button. In the displayed Save dialog box, select the export path and enter the name of the image to export the current statistical chart as an image.
  • Method 2: Right click the mouse in the current statistical chart window and select the Export as Image command in the pop-up Context Menu.

Related content

Diagram Overview

Diagram Type

Conversion of Charts to Thematic Maps

Interact with Chart Linkage

Using the Diagram template