This topic provides an overview of area charts and an example on how to use area charts. This topic also describes how to configure area chart styles and how to delete an area chart.

Prerequisites

A dashboard is created. For more information, see Create a standard dashboard.

Overview

Similar to the Line chart, an area chart displays the overall data trend and proportions within a specific period of time.

When you create an area chart, you must specify Value Axis (Mea.), Category Axis (Dim.), and Color Legend (Dim.).
  • You must specify at least one dimension for Category Axis (Dim.).
  • You must specify at least one measure for Value Axis (Mea.).
  • You can specify only one dimension for Color Legend (Dim.).
    Note Color Legend (Dim.) is applicable only when Value Axis (Mea.) has one measure.
Effect diagram - 3.11

Example

The following example shows how to use an area chart to visualize the order quantity of each product in different provinces. In this example, the company_sales_record dataset is used.

  1. Perform the operations shown in the following figure to create a dashboard. Create a dashboard
  2. In the Create Dashboard dialog box, select Standard or Full Screen, and click OK.
    In this example, Standard is selected. Confirmation message
  3. On the dashboard edit page, click Division of square paper in the top menu bar and click the Area Chart icon.
    International site
  4. On the Data tab under Chart Design, configure the required parameters.
    1. Double-click the required dimensions and measures, or drag them to the destination fields.
      • In the Dimensions list, double-click province. You can also drag this dimension to the Category Axis (Dim.) field
      • In the Dimensions list, double-click product_type. You can also drag this dimension to the Color Legend (Dim.) field.
      • In the Dimensions list, double-click area. You can also drag this dimension to the Filters field.
      • In the Measures list, double-click order_number. You can also drag this measure to the Value Axis (Mea.) field.
    2. In the Filters field, click the icon on the right of the area measure to configure filters.
      In this example, Filter Method is set to By Enumeration, Query Mode is set to Single Choice, and Filter Condition is set to East China. 1
  5. Click Update to update the area chart.
    Updated

    You can click the 1 icon next to Value Axis (Mea.) to modify the display name, aggregation method, and value display format of a measure. For more information, see Configure a chart.

  6. On the Style tab, configure parameters in the Basic Information, Chart Style, Functionality, Axes, and Series Settings sections.
    For more information, see Configure area chart styles.
  7. On the Advanced tab, configure parameters in the Advanced Settings, Metric Analysis, and Label sections.
    Parameter Option Description
    Advanced Settings Auto Refresh After you select Auto Refresh, the system refreshes the area chart as scheduled. For example, if you select Auto Refresh, enter 5, and then select Minutes, the system automatically refreshes the area chart every 5 minutes.
    Filter Interaction After you configure Filter Interaction and click an area or field in the area chart, data in other charts that are associated with this chart is updated. For more information, see Configure the filter interaction feature.
    Hyperlink After you configure Hyperlink, you are directed to the linked report when you click a field in the area chart. You can set Hyperlink to Parameter or External Link. If you select Parameter, you must configure global parameters. For more information, see Configure the hyperlink feature.
    Metric Analysis Auxiliary Line Auxiliary lines can be used to show the difference between the value of a measure and the reference value indicated by an auxiliary line. The reference value indicated by an auxiliary line can be a fixed value or a calculated value. You can use the following calculated values: average, maximum, minimum, and median. For more information, see Auxiliary line.
    Trendline A trendline displays the overall trend of the data that you selected. Quick BI provides the following trendline options: Intelligent, Linear, Logarithmic, Exponential, Polynomial, and Power. For more information, see Metric analysis.
    Note Trendline is unavailable for stacked area charts and 100% stacked area charts.
    Label - Labels are used to mark the values of a specific dimension in the area chart. For more information, see Label.
  8. Click Save in the upper-right corner of the page to save the settings.

Configure area chart styles

  • In the Basic Information section, configure Show Title and Description, Description, Endnote, and Show Link.
    Note If Show Link is selected, you also need to configure Link Text and Link Address. If you click a field in the line chart, you are redirected to the linked report or an external link.
    You can switch a line chart to an area chart, stacked area chart, or 100% stacked area chart. Chart type
  • In the Chart Style section, configure the area chart style.
    Parameter Description
    Show Labels Specifies whether to display labels in the area chart.

    If a chart has a large number of measures, select Show Labels to show all the measure labels.

    Label Display Mode Options: Smart Display and Full Display.
    • If a chart has a large number of dimensions and the scroll bar is not displayed, select Smart Display to show only some data labels.
    • If a chart has a small number of dimensions or the scroll bar is not displayed, select Full Display to show all the data labels.
    Show Legend The following five display modes are available. The legend display mode.
    Color Settings You can configure colors for the area chart. Colors - 3.11
    Dual Y-Axis Specifies whether to show two Y axes in the area chart.
    The dual y-axis takes effect only when two or more measures are added. Dual Y-axis - 3.11
    Note If you select Dual Y-Axis, Right Y-Axis appears in the Axes section.
    Show Axis
    Stacked and 100% Stacked You can switch between area charts, stacked area charts, and 100% stacked area charts. Effect example - 3.11
  • In the Functionality section, configure Show Scroll Bar, Dimension Value Sampling, and Null Value Operation. 311
  • In the Axes section, configure axis styles.
    Parameter Option Description
    X-Axis Axis Title The title for the x-axis.
    Unit The unit for the x-axis.
    Show Title and Unit Specifies whether to show the title and unit of the x-axis.
    Show Axis Specifies whether to show the x-axis, including the line style, line width, and color.
    Show Value Specifies whether to show values on the x-axis.
    Gridlines Specifies whether to show gridlines on the x-axis, including the line style, line width, and color.
    Show Scale Specifies whether to show scales on the x-axis.
    Left Y-Axis Axis Title The title for the left y-axis.
    Unit The unit for the left y-axis.
    Minimum and Maximum Specifies whether to show the minimum and maximum values on the left y-axis.
    • If you select Default, the minimum and maximum values automatically appear on the left y-axis.
    • If you clear Default, you need to manually configure the minimum and maximum values on the left y-axis.
    Note Minimum and maximum values are not supported in stacked area charts or 100% stacked area charts.
    Auto Magnify Value Differences Specifies whether to automatically magnify value differences on the left y-axis.
    Note If Auto Magnify Value Differences is selected, the axis range is adjusted based on the minimum and maximum values of the displayed data.
    Show Title and Unit Specifies whether to show the title and unit of the left y-axis.
    Show Axis Specifies whether to show the left y-axis, including the line style, line width, and color.
    Y-axis Label Settings The display formats for labels on the left y-axis. Options: AutoFit, Custom, and Manual.
    Note You can also configure the measure display formats on the Data tab. For more information, see Configure a chart.
    Show Value Specifies whether to show values on the left y-axis.
    Gridlines Specifies whether to show gridlines on the left y-axis, including the line style, line width, and color.
    Show Scale Specifies whether to show scales on the left y-axis.
    Note If you select Dual Y-Axis, you also need to configure the right y-axis. The steps to configure the right y-axis are the same as the steps to configure the left y-axis.
  • In the Series Settings section, configure the series.
    Note You need to configure Display Name and Number Formatting under Series Settings only when Color Legend (Dim.) is specified.
    Parameter Description
    Series You can specify a measure based on your business requirements.
    Display Name You can specify an alias for a field in the area chart.
    Show Labels Specifies whether to show labels and label colors.
    Show Boundary Values Specifies whether to show the labels of the maximum and minimum values in the area chart.
    Note Labels of the minimum and maximum values cannot be displayed in stacked area charts or 100% stacked area charts.
    Number Formatting The number display format. Options: AutoFit, Customer, and Manual.
    The following figure shows the updated area chart. Chart Type
    Note For more information about chart styles, see Configure a chart.

Delete a chart

  1. Click the More icon in the upper-right corner of the line chart.
  2. Select Delete. The line chart is deleted.