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

Prerequisites

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

Overview

  • A horizontal bar chart shows data changes within a specific period of time, or compares different groups of data. For example, you can use a horizontal bar chart to show the work progress of different members in a project team.
  • A horizontal bar chart is similar to the Line chart. When you create a horizontal bar chart, you must specify Value Axis (Mea.), Category Axis (Dim.), and Color Legend (Dim.).
    • You must specify at least one measure for Value Axis (Mea.).
    • You must specify at least one dimension for Category Axis (Dim.).
    • You can specify only one dimension for Color Legend (Dim.).
      Note Color Legend (Dim.) can be used when Value Axis (Mea.) has only one measure.
Example - 3.11

Example

The following example shows how to use a horizontal bar chart to compare the shipping costs of different products in different cities. 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 the Division of square paper icon in the top menu bar and click the Horizontal Bar Chart icon. International site
  4. On the Data tab, configure the horizontal bar chart.
    1. Double-click the required dimensions and measures, or drag them to the destination fields.
      • In the Dimensions list, double-click city. 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, drag city to the Filters field.
      • In the Measures list, double-click shipping_cost. You can also drag this measure to the Value Axis (Mea.) field.
    2. Click the icon next to city in the Filters section to configure filters.
      In this example, Filtering Method is set to By Enumeration, Query Mode is set to Multiple Choice, and Filter Condition is set to Beijing, Shanghai, Chongqing, and Tianjin. 1
  5. Click Update to update the horizontal bar 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 horizontal bar 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 horizontal bar chart as scheduled. For example, if you select Auto Refresh, enter 5, and then select Minutes, the system refreshes the horizontal bar chart every 5 minutes.
    Filter Interaction After you configure Filter Interaction and click an area or field in the horizontal bar 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 horizontal bar 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 types of trendlines: Intelligent, Linear, Logarithmic, Exponential, Polynomial, and Power. For more information, see Metric analysis.
    Label - Labels are used to mark the values of a specific dimension in the horizontal bar chart. For more information, see Label.
  8. Click Save in the upper-right corner of the page to save the settings.

Configure horizontal bar 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 horizontal bar chart, you are redirected to the linked report or an external link.
    You can switch among Horizontal Bar Chart, Stacked Horizontal Bar Chart, and 100% Stacked Horizontal Bar Chart. International site
  • In the Chart Style section, modify the chart style based on your business requirements.
    Parameter Description
    Show Labels Options: Smart Display and Full Display.

    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 labels.
    • If a chart has a small number of dimensions or the scroll bar is not displayed, select Full Display to show all the labels.
    Alignment Quick BI provides two alignment modes: Align Left and Align Right. Alignment mode - 3.11
    Show Legend The following five display modes are available. The legend display mode.
    Color Settings You can configure colors for the horizontal bar chart. Color - 3.11
    Dual Y-Axis Specifies whether to show two Y axes in the horizontal bar 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.
    Stacked and 100% Stacked You can switch among Horizontal Bar Chart, Stacked Horizontal Bar Chart, and 100% Stacked Horizontal Bar Chart. Horizontal bar chart - 3.11
  • In the Functionality section, configure Show Scroll Bar and Dimension Value Sampling. 311
  • In the Axes section, configure axis styles.
    Parameter Option Description
    Vertical Axis Axis Title The title of the vertical axis.
    Unit The unit of the vertical axis.
    Show Title and Unit Specifies whether to show the title and unit of the vertical axis.
    Show Axis Specifies whether to show the vertical axis, including the line type, line width, and color.
    Gridlines Specifies whether to show gridlines on the vertical axis, including the line type, line width, and color.
    Show Scale Specifies whether to show scales on the vertical axis.
    Lower Axis Axis Title The title of the lower axis.
    Unit The unit of the lower axis.
    Minimum and Maximum Specifies whether to show the maximum and minimum values on the lower axis.
    Note If you select Default, the minimum and maximum values are automatically displayed on the lower axis. If you clear Default, you need to manually configure the minimum and maximum values on the lower axis.
    Auto Magnify Value Differences If Auto Magnify Value Differences is selected, the axis range is adjusted based on the minimum and maximum values.
    Show Title and Unit Specifies whether to show the title and unit of the lower axis.
    Show Axis Specifies whether to display the lower axis, including the line type, line width, and color.
    Y-axis Label Settings The display formats for labels on the lower axis. Options: AutoFit, Custom, and Manual.
    Show Value Specifies whether to show label values on the lower axis.
    Gridlines Specifies whether to show gridlines on the lower axis, including the line style, width, and color.
    Show Scale Specifies whether to show scales on the lower axis.
    Note If you select Dual Y-Axis, the configurations of the upper axis are the same as those of the lower axis.
  • In the Series Settings section, configure the series.
    Note You need to configure Display Name and Number Formatting in the Series Settings section only when Color Legend (Dim.) is used.
    Parameter Description
    Series The series. You can specify a measure or dimension based on your business requirements.
    Display Name The alias for a field that is displayed in the horizontal bar chart.
    Show Labels Specifies whether to show labels. If you select show labels, label colors are applied.
    Show Boundary Values Specifies whether to show the labels of the maximum and minimum values in the horizontal bar chart.
    Note This parameter is unavailable in stacked horizontal bar charts and 100% stacked horizontal bar charts.
    Number Formatting The display format of numbers. Options: AutoFit, Custom, and Manual
    The following figure shows the updated horizontal bar 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.