Combination Chart

更新时间:
复制 MD 格式

A combination chart uses a dual Y-axis to display data on different scales. You can combine multiple chart types, such as line, column, and area charts, into a single chart. It also supports complex scenarios like stacked and 100% stacked layouts, making it ideal for visualizing trends across different projects.

Prerequisites

You have created a dashboard. For more information, see Create a dashboard.

Overview

  • Use cases

    • Trend-based charts show how continuous data changes over time and are ideal for visualizing trends at regular intervals.

    • Use an area chart to analyze how data changes over time, such as identifying growth, decline, cyclical patterns, or exponential increases.

  • Benefits

    • Calculation capabilities: Easily configure period-over-period comparisons, cumulative calculations, smart reference lines, and trendlines.

    • Visualization features: Supports line, area, stacked area, and 100% stacked area charts. You can configure data labels, a legend, and an overview axis.

    • Data comparison and annotation: Compare same-period data and add numerical annotations.

  • Example组合图效果图

Limitations

A combination chart consists of primary measures, secondary measures, a category axis, and a color legend:

  • The primary and secondary axes are determined by the measures in your data. You must select at least one measure, such as order amount and profit amount.

  • The category axis is determined by the dimensions in your data. You must select at least one dimension, such as order date (year).

  • The color legend is determined by a dimension in your data. You can select a maximum of one dimension, such as shipping method.

    Note

    The color legend can be enabled only when one measure field is selected on the primary or secondary value axis.

Configure Chart Data

  1. On the Data tab, select the required dimension and measure fields:

    • In the measure list, find Order Amount, then double-click or drag it to the primary measures area.

    • In the measure list, find Profit Amount, then double-click or drag it to the secondary measures area.

    • In the dimension list, find Order Date (year), then double-click or drag it to the category axis area.

  2. Click Update. The chart updates automatically.

    image..png

  3. (Optional) To view data for only specific cities, you can set a filter to show only the data you need.image

  4. Auto refresh

    To automatically refresh chart data, enable this option and set a time interval. For example, if you set the duration to 5 minutes, the chart refreshes every 5 minutes.

Configure Chart Style

  • In the Style pane, on the Fields tab, you can change the chart style.

    In this example, for the Profit Amount field under secondary measures, set its display type to Line.线-311

    To change the chart's stacking mode, hover over Standard.常规-311

The following sections describe the style settings for the chart. For general style settings, see Configure the chart title area.

You can use the search box at the top of the configuration pane to quickly find settings. Click the image..png icon to Expand/Collapse all categories.

柱体..gif

Drawing Area

In the Drawing area section, configure the combination chart style.

image..png

Setting

Description

Color settings

Set the color scheme for the combination chart.

Chart orientation

Set the chart orientation to Horizontal or Vertical.

Chart alignment

When the orientation is Vertical, you can set the alignment to Left or Right.

image..png

Line

Configure the line style. You can set the line type to Smooth or Straight, configure the line style and thickness, choose whether to show markers and their style, and set the method for null value handling.

image

Column

Set the width of the columns.

条形图主题宽度..gif

Mobile default selection

After enabling this setting, you can set the Default selection to Last global dimension value or Last dimension value of specified series.

Axes

In the Axes section, configure axis styles. By default, axes are shown.

Select Show dual Y-axis to display separate left and right axes. This setting takes effect only when two or more measures are added. When this option is selected, the right Y-axis section appears in the Axes pane.

image..png

Name

Setting

Description

X-axis

Show X-axis

Shows or hides the X-axis.

Show title and unit

Shows or hides the axis title and unit on the X-axis.

Show axis labels

Shows or hides labels on the X-axis. You can also configure the axis label display rules and text style.

Content to display

Set whether to display some or all dimensions on the axis.

image.png

Show tick marks

Shows or hides tick marks on the X-axis.

Show axis line

Shows or hides the X-axis line. You can configure its line style, width, and color.

Show gridlines

Shows or hides gridlines for the X-axis. You can configure their line style, width, and color.

left Y-axis

Invert Y-axis scale

Inverts the Y-axis scale.

组合图-Y轴翻转..gif

Show left Y-axis

Shows or hides the left Y-axis.

Show title and unit

Shows or hides the axis title and unit.

Show axis labels

Shows or hides labels on the Y-axis. If shown, you can configure the axis label display format and text style. The axis label display format can be set to Auto or Custom.

  • The default mode is Auto. In this mode, the axis label inherits the data display format settings of the measure field. If multiple measure fields are present, the settings of the first field apply.

  • In Custom mode, click the image icon to configure the data format in the Data Display Format Settings dialog box. For information about the settings in the dialog box, see Data display formats > Custom.

Show tick marks

Shows or hides tick marks on the left Y-axis.

Show axis line

Shows or hides the left Y-axis line. You can configure its line style, width, and color.

Show gridlines

Shows or hides gridlines for the left Y-axis. You can configure their line style, width, and color.

Axis value range and interval

  • Supports Auto and manual configuration of the Maximum/Minimum values for the left Y-axis range.

  • Supports setting a Custom interval by step size or number of divisions.

99.gif

Note

You need to configure the right Y-axis only when Show dual Y-axis is selected. The settings are the same as for the left Y-axis.

Legend

In the Legend section, click the image icon to enable the legend and configure its style.

  • PC configuration

    image

    Setting

    Description

    Style

    Set the style of the legend icons. Options include Auto, Line only, and Line and marker.

    111

    Note
    • The legend synchronizes with the marker style set in the chart. If no marker style is configured, solid circles are displayed by default.

    • When you select Scale legend symbols with text in Theme Design > General Content Style, the size and line thickness of the legend icons adjust proportionally to the chart's line thickness and legend text size.

    • This setting only affects the line and area charts within the combination chart.

    Position

    Set the display position and alignment of the legend.

    • When the position is set to Top or Bottom, you can choose left, center, or right alignment.

    • When the position is set to Left or Right, you can choose top, center, or bottom alignment. You can also set the distance between the legend and the chart content.

    Text

    Set the text style for the legend, including font color, size, weight, and italics.

  • Mobile configuration

    image

    Setting

    Description

    Position

    Set the display position and alignment of the legend.

    • When the position is set to Top or Bottom, you can choose left, center, or right alignment.

    • When the position is set to Left or Right, you can choose top, center, or bottom alignment. You can also set the distance between the legend and the chart content.

    Note

    When the position is set to Top, you can enable labels below the legend, in which case custom alignment is not supported.

    Text

    Set the text style for measure names in the legend, including font color, size, weight, and italics.

    Show label content

    When Position is set to Top, click the image icon to enable labels below the legend.

    Style

    Set the layout style for the label text below the legend. The following options are available:

    • Multi-line Equal-width: Labels are automatically arranged in an equal-width grid based on the number of columns set in Max items per row and the number of rows set in Max items per page.image

    • Single-line Tiled: All label content is displayed in a single row.image

    • Plain Text: Only text is displayed without icons, and the text color matches the line color of the corresponding measure in the chart.image

    When unselected, display metric as

    When Style is set to Multi-line Equal-width or Single-line Tiled, you can configure how to display a metric when a legend item is unselected. You can choose to display it as "-" or leave it blank.111

    Text style

    When Style is set to Multi-line Equal-width or Single-line Tiled, you can configure the text style for the Values.

    Show full text

    When Style is set to Multi-line Equal-width or Single-line Tiled, long measure names may be truncated. If you need to display the full measure names, select Show full text.

    Show tooltip fields

    When this option is enabled, the fields you configured in the Tooltip/Measure section of the data pane are displayed in the legend area.image

    Note

    Displaying tooltip fields is not supported in scenarios where data is split by dimension values (that is, the color legend is a dimension).

Data Labels

In the Data Labels section, configure whether to show data labels and their styles.

image

Setting

Description

Full display

After you enable full display for data labels, the system automatically adjusts label positions to prevent them from overlapping. If there are too many data labels, some may not be displayed because they exceed the axis area. You can also select Allow data labels to overlap.

Text

Set the text style for the labels.

Tooltip

In the Tooltip section, click the image icon to enable tooltips and configure their settings.

  • PC configuration

    image

    Setting

    Description

    Display mode

    Set the tooltip display mode. Options are By single data point and By dimension value.

    Content

    Select the data content to display in the tooltip. The available content depends on the configured display mode.

    When the display mode is By single data point, you can show percentages. When the display mode is By dimension value, you can show totals and percentages.

    • Percentage: The percentage of a data point relative to the total under the current dimension. For example, the percentage of profit amount out of total revenue for office supplies. When you choose to display percentage data, you can also set the number of decimal places to 0, 1, or 2 in Decimal Places for Percentage.

    • Total: The sum of all measures under the current dimension. For example, the total sales amount across all regions for the year 2025.

    Note

    When you drag secondary measures into the field, you can configure the left Y-axis and the right Y-axis separately.

    Background color

    Set the background fill color for the tooltip.

    Text

    Set the style of the text in the tooltip, including font color, size, weight, and italics.

  • Mobile configuration

    image

    Setting

    Description

    Hover bubble

    Click the image icon to enable the hover bubble display (①).

    Content

    Set the data content to display in the hover bubble. Options include Percentage and Total.

    Note

    When you drag secondary measures into the field, you can configure the left Y-axis and the right Y-axis separately.

    • Percentage: The percentage of a data point relative to the total under the current dimension. For example, the percentage of profit amount out of total revenue for office supplies. When you choose to display percentage data, you can also set the number of decimal places to 0, 1, or 2 in Decimal Places for Percentage.

    • Total: The sum of all measures under the current dimension. For example, the total sales amount across all regions for the year 2025.

    Background color

    Set the background fill color for the hover bubble.

    Text

    Set the style of the text in the hover bubble, including font color, size, weight, and italics.

    Show axis dimension

    Click the image icon to enable the axis dimension display (②).

    Background color

    Set the background fill color for the axis dimension label.

    Text

    Set the text style for the axis dimension label, including font color, weight, and italics.

Series Settings

In the Series Settings section, configure series styles.

image

Note

You can set Alias and Series value display format in Series Settings only when Color legend is enabled in the Field configuration panel.

Setting

Description

Select series field

Select a dimension or measure item based on your business scenario.

Alias

Set a custom name for the field.

This option is available only when a color legend is configured.

Show data labels

Select whether to show data labels and set their position and text format.

Series value display format

Configure the display format for series values. You can select Auto or Custom.

  • Auto: This is the default option. The series values inherit the data display format settings of the corresponding measure field.

  • Custom: Click the image icon to configure the data format in the Data Display Format Settings dialog box. For information about the settings, see Data display formats > Custom.

This option is available only when a color legend is configured.

Show min/max values

Shows or hides labels for the minimum and maximum values in the chart. If enabled, you can set the position of the labels, the content to display (Maximum or Minimum), the label's background fill color, and the label's text style.

Note

This feature is not supported for stacked and 100% stacked charts.

View Controls

When chart axis data is too dense to display clearly, click the image icon to enable view controls. This ensures data integrity and readability while letting viewers dynamically adjust the visible range by scrolling.

Control the visible range on the chart axis by using an overview axis or a scroll bar.

image

Setting

Description

Overview axis

When you select overview axis, a simplified chart showing the full data trend (the overview axis) appears at the bottom. Viewers can drag the selection area to quickly browse all data or focus on a specific range. The overview axis uses absolute coordinates, meaning the selected interval corresponds to a fixed number of data points on the actual axis. This is suitable for comparative analysis or scenarios requiring direct positioning.image By default, the overview axis appears only when the data volume exceeds the display width of the chart container. If you want the overview axis to always be visible, select Always show. Once this option is selected, the overview axis is displayed even if the chart data does not fill the screen.

Scroll bar

When you select scroll bar, a horizontal scroll bar appears at the bottom of the chart. Viewers can drag the slider to move the view window left or right. The scroll bar uses relative proportions, meaning the slider's length and position are determined by the ratio of the visible window to the total data range. This is suitable for general browsing scenarios.image You can also set the minimum category width for the scroll bar to limit the amount of data in the current chart window. This ensures that the chart content is clearly displayed within the visible area and avoids visual clutter from overlapping data labels or overly dense data points. The minimum category width is 32px by default, with a range of 16-100px.

After a minimum category width is set, the scroll bar appears if the actual category width allocated for the full chart is smaller than this value. When the scroll bar is enabled, chart elements and data labels are contained within the axis area. Any parts that extend beyond this area, such as markers or data labels, are automatically truncated or repositioned to fit.

Note

If no view control is configured for the chart and the chart size is too small, the system automatically enables a view control and selects the overview axis. The overview axis is displayed only when the amount of data exceeds the container's display width.

Analysis Configuration

Category

Name

Description

Interactions

Drill-down

When you have configured the drill-down feature for the chart, you can configure the display style of the drill-down hierarchy. For more information, see Drill-down.

Linkage

When the data you need to analyze is in different charts, you can use chart linkage to associate multiple charts for data analysis. For specific settings, see Linkage.

Jump

If your analysis involves multiple dashboards, use jumps to connect them. Jumps can be a parameter jump or an external link. For more information, see Jump.

Analysis and alerting

Reference line

A reference line helps you compare the current measure value against a reference value, which can be a fixed value or a calculated value (average, maximum, minimum, or median). For more information, see Analysis & Alerting.

Trendline

A trendline shows the overall trend of the current data. Available types include Intelligent Recommendation, Linear, Logarithmic, Exponential, Polynomial, and Power. For more information, see Analysis and Alerts.

Annotation

-

When data in the chart is abnormal or requires attention, you can add annotations using color highlights, icons, comments, or data points to identify anomalies and take action. For more information, see Annotation.

Next Steps

  • To allow others to view the dashboard, share it with specific users. For more information, see Publish a dashboard.

  • To create complex, topic-based analysis pages with navigation menus, integrate your dashboards into a data portal. For more information, see Data Portal.