Updated on 2023-03-09 GMT+08:00

Dual Y-Axis Combination

A dual Y-axis combination chart consists of a bar chart and a line chart and displays the values of different series under the same category. In a dual Y-axis combination chart, you can view the data comparison between multiple series under each category and the data change trend of each series.

This section describes parameters of a dual Y-axis combination chart.

Figure 1 Dual Y-axis combination chart

Pattern

  • Size/Position
    • Size: width and height of the component. Unit: pixel.
    • Position: position where the component is located in the canvas. Unit: pixel.
  • Global Style

    Font: font of the text.

  • Column Style
    • Column Width: width of the column.
    • Column Angle: round-corner angle of the column.
    • Series Spacing: distance between two adjacent series.
  • Margin
    • Top: spacing between the top sides of the chart and the component layer. You can enter a value or click to adjust the spacing.
    • Bottom: spacing between the bottom sides of the chart and the component. You can enter a value or click to adjust the spacing.
    • Left: spacing between the left sides of the chart and the component. You can enter a value or click to adjust the spacing.
    • Right: spacing between the right sides of the chart and the component. You can enter a value or click to adjust the spacing.
  • X Axis: to show or hide the X axis. When this option is selected, you can set the X axis style.
    • Font Size: font size of the axis label text.
    • Color: font color of the axis label text.
    • Font Width: font width of the axis label text.
    • Axis Label: to show or hide the axis labels. When this function is enabled, you can set the angle of the axis label text.
    • Coordinate Axis: to show or hide the axis. You can set the color of the axis when you select this option.
    • Grid Line: to show or hide the grid lines. You can set the color of the grid lines when you select this option.
    Figure 2 X axis of a dual Y-axis combination chart
  • Y1 Axis
    • Font Size: font size of the axis label text.
    • Color: font color of the axis label text.
    • Font Width: font width of the axis label text.
    • Axis Label: to show or hide the axis labels. When this function is enabled, you can set the following parameters:
      • Display Format: display format of the scale value on the axis.
      • Min. Value: the minimum value of the axis. You can enter a value or select a value from the drop-down list. When this parameter is set to the minimum value, the start value of the axis is the minimum value in the current data.
      • Max. Value: the maximum value of the axis. You can enter a value or select a value from the drop-down list. When this parameter is set to the maximum value, the start value of the axis is the maximum value in the current data.
      • Scales: intervals of data items on the coordinate axis.
    • Axis Unit: to show or hide the axis unit. When this function is enabled, the axis unit is displayed on the top of the chart. The unit can be displayed only when Top under Margin is set to a value greater than or equal to 40.
      • Unit: unit of the coordinate axis, for example, kilometer, byte/second, or GB.
      • Color: font color of the text.
    • Coordinate Axis: to show or hide the axis. You can set the color of the axis when you select this option.
    • Grid Line: to show or hide the grid lines. You can set the color of the grid lines when you select this option.
    Figure 3 Y1 axis of a dual Y-axis combination chart
  • Y2 Axis

    The Y2 axis is the Y axis on the right. The configuration items are the same as those of the Y1 axis. For details, see the description of Y Axis.

  • Legend: to show or hide the legend. When this option is selected, you can set the legend style.
    • Text: text style of the legend, including Font Size, Color, and Font Width.
    • Layout
      • Legend Spacing: distance between two adjacent legends.
      • Left/Right Spacing: distance between the legend and the top boundary of the component.
      • Position: position of the legend.
    Figure 4 Legends of a dual Y-axis combination chart
  • Message: to show or hide the prompt information. After this function is enabled, a message is displayed when you mouse over or click on the screen during the screen preview.
    • Triggering Type: type of the prompt message.
    • Color: font color of the message.
    • Font Size: font size of the message.
    • Font Width: font width of the message.
    Figure 5 Message
  • Animation
    • Click or next to Animation to hide or show animation, respectively.
    • Duration: duration of the first rendering of the component, in ms.
    • Animation Effect: The system provides multiple common animation slow-moving effects.
    • Animate in Order: If this option is selected, the series are animated in sequence. If this option is deselected, all series are animated at the same time.
    • Duration After Change: animation duration when the component data is updated, in ms.
    • Start from Previous Position: If this option is selected, the animation is played from the position of the previous data when the component data is updated. If this option is deselected, the animation is played from the initial position when the component data is updated.
    Figure 6 Animation (line chart)

Data

The dual Y-axis combination chart contains three fields by default: x, y, and s.

  • Data Mapping
    • x: category of a line chart or bar chart, corresponding to the X axis.
    • y: data of series, corresponding to Y1 axis or Y2 axis.
    • s: series. You can set a value of the s field to a series. You can add multiple series. The value of each series can be mapped to different Y coordinates.

      Click on the right of s to add a series. To delete an added series, click on the right of the series.

      Add a series as follows:
      • Series Value: field name in the mapped source data. If the series value is left blank, the value of the corresponding Y field is used by default.
      • Bar: whether to display the bar chart. If this parameter is selected, you can set the style of the bar chart. The configuration items are as follows:

        Series Name: self-definable. If the series name is empty, the series value is used as the series name by default.

        Color: color of the column in the series.

        Stack: stack name. You can enter a user-defined name. If the same stack name is set for different series of the same category (with the same x value), the series data is displayed in the stack.

        Value Tag: to show or hide the value tag. After selecting this option, you can set the font size, color, font width, and position of the value tag.

      • Line: whether to display the line chart. If this parameter is selected, you can set the style of the line chart.
      • Reference Axis: Y1 axis or Y2 axis.
  • Data Source Type: to select the data source of the chart. Multiple data sources are provided for you to select. You need to add data sources first. For details, see Data Connection Overview.
  • Converter: Select a converter to convert data into the data that meets the display requirements. For details, see Using a Converter.
  • Automatic Update: If you select Automatic Update and set Update Interval, the data is automatically updated based on the interval.
  • Preview Result: Click Preview Result to view the information about the selected data source. You can click Update Query to manually update the component data when the data source changes.

Interaction

For details about whether the component supports the interaction function and how to use the interaction function, see Configuring Component Interaction.