A vertical bar chart displays data trends over time and compares data across different categories. For example, you can use a vertical bar chart to compare traffic flow at an intersection during different time periods. This topic describes how to add data to a vertical bar chart and configure its style.
Limits
Prerequisites: A dashboard is created. For more information, see Create a Dashboard.
A vertical bar chart consists of Value Axis (Mea.), Category Axis (Dim.), and Color Legend (Dim.):
You must specify at least one dimension for Category Axis (Dim.), such as province or product_type.
You must specify at least one measure for Value Axis (Mea.), such as order_number and profit_amt.
You can specify only one dimension for Color Legend (Dim.), such as shipping_type.
NoteYou can specify Color Legend (Dim.) only when Value Axis (Mea.) has one measure.
Overview
Scenarios
A vertical bar chart helps you compare data across different categories. The lengths of columns indicate values.
Advantages
Powerful computing capabilities: A vertical bar chart allows you to configure parameters such as Comparison, Cumulative Calculation, Gridlines, and Trendline.
Abundant data visualization: The chart type can be a vertical bar chart, a stacked vertical bar chart, or a 100% stacked vertical bar chart. You can configure parameters such as Label, Show Legend, and Show Scroll Bar.
Data comparison and labeling: A vertical bar chart allows you to compare data in the same period and label data with numbers.
Example
Configure a Vertical Bar Chart
On the Data tab, select the required dimensions and measures:
In the Dimensions list, find Province, and then double-click or drag it to the Category Axis (Dim.) section.
In the Dimensions list, find Product Type, and then double-click or drag it to the Color Legend (Dim.) section.
In the Measures list, find Shipping Cost, and then double-click or drag it to the Value Axis (Mea.) section.
NoteYou can drag the same field to both the Category Axis section and the Color Legend section to color the bars based on different dimension values. The implementation effects in different scenarios are as follows:
When only one field exists in both the Category Axis section and the Value Axis section, the number of bars = the number of dimension values in the category axis.
When multiple measure fields exist in the Value Axis section, the chart displays the first measure by default. You need to manually open the field filtering panel to switch to other measures.
When multiple dimension fields exist in the Category Axis section, the number of bars is calculated by multiplying the number of dimension values of each dimension. For example, in the following figure, the number of bars = the number of dimension values in the Region dimension × the number of dimension values in the Order Level dimension.
Click Update. The system automatically updates the chart.
When you need to view data only in a specific Region, you can set a filter to filter the required data.
(Optional) Auto Refresh
After you select Auto Refresh, the system automatically refreshes the vertical bar chart at a specified time interval. For example, if you select this option, set the time interval to 5, and select Minutes as the unit, the system refreshes the vertical bar chart every 5 minutes.
(Optional) You can continue to add dimension fields to Split/Dimension to more intuitively display data trends under different dimension values through the facet mode.
NoteYou can add only one split dimension field. The facet mode has the following functional limitations.
Fields: For fields in Split/Dimension, the advanced calculation feature supports only topN and None.
Style: The coordinate axis does not support displaying dual Y-axes. The auxiliary display does not support setting a scroll bar.
Analysis: Only data interaction can be set. Advanced settings, analysis alerts, annotations, and intelligent insights are not supported.
Configure the Style of a Vertical Bar Chart
This section describes how to configure the style of a vertical bar chart. For information about how to configure the chart title, see Configure the Chart Title.
You can enter keywords in the search box at the top of the configuration area to quickly find configuration items. You can also click 
on the right to expand or collapse all categories.
Drawing Area
In the Drawing Area section, configure the style of the vertical bar chart.
Configuration item | Description |
Color Settings | You can set the overall color for the bars, enable the gradient effect, and set the transparency of the bars. |
Chart Type | Set the chart type. The options are Vertical Bar Chart, Stacked Vertical Bar Chart, and 100% Stacked Vertical Bar Chart. |
Bar Width and Border Radius | You can set the width and border radius of the bars. |
Stacked, 100% Stacked | You can switch between vertical bar charts, stacked vertical bar charts, and 100% stacked vertical bar charts.
|
Fill with Graphics | When Chart Type is set to Vertical Bar Chart, you can fill the bar area with icons that have numerical meanings. In this case, we recommend that you disable the measure axis. You can select Material or Image Field for filling.
You can also set Value Represented by a Single Graphic, Number of Rows, and whether to Compress Layout.
|
Default Selection on Mobile | After you select this option, you can select Last Dimension Value Globally or Last Dimension Value of Specified Series for Default Selection. |
Image Field and the field type is image.
Facet
In facet mode, you can set the layout and style of chart arrangement in the Facet section.
The facet mode takes effect only when related fields are configured in Split/Dimension.
Configuration item | Description | |
Layout Style | Set the chart arrangement layout. Two modes are supported: Single Column Comparison and Grid Distribution. | |
Share Coordinate Axis | Specify whether the charts need to share the same coordinate axis.
| |
Show Line Separator | Specify whether to display line separators between charts. When this option is enabled, you can further configure the color and style of the line separators. | |
Number of Columns | When the layout style is set to Grid Distribution, you can set the number of columns for chart arrangement. The default value is Auto. You can also customize the number of columns based on your actual needs. Note
| |
Minimum Width and Height of Facet Block | Set the minimum width and height of each chart. The configurable information varies depending on the layout style.
| |
Row and Column Spacing | Set the row and column spacing between charts. The configurable information varies depending on the layout style.
| |
Split Label | Position | Set the display position of dimension value labels. You can set them to appear Above Chart or Below Chart. |
Text | Set the font color and style of dimension value labels. | |
Alignment | Set the alignment of dimension value labels. | |
at the top of the current page.
Coordinate Axis
In the Coordinate Axis section, set the style of the coordinate axis. The coordinate axis is displayed by default.
You can select Show Dual Y-Axes. The dual Y-axes take effect only when the number of added measures is greater than or equal to 2. After you select this option, Right Y-Axis appears in the Coordinate Axis section.
Name | Configuration item | Description |
X-axis | Show X-axis | Specifies whether to display the X-axis. |
Show Title And Unit | Specifies whether to show the Axis Title and Unit on the X-axis. | |
Show Axis Labels | Specifies whether to show labels on the X-axis, along with axis label display rules and text style. | |
Display Content | Specifies whether to display partial or all dimensions.
| |
Show Scales | Specifies whether to show scales on the X-axis. | |
Show Axis | Specifies whether to show the X-axis, including line style, line width, and color of the X-axis. | |
Show Gridlines | Specifies whether to show gridlines on the X-axis, including the line style, line width, and color of the X-axis. | |
Left Y-axis | Flip Y-axis Scale | You can flip the Y-axis scale values.
|
Show Left Y-axis | Specifies whether to show the left Y-axis. | |
Show Title And Unit | Specifies whether to show the Axis Title and Unit. | |
Show Axis Labels | Specifies whether to show labels on the left Y-axis, along with label and scale range, and axis label display format settings. | |
Show Scales | Specifies whether to show scales on the left Y-axis. | |
Show Axis | Specifies whether to show the left Y-axis, including the line style, line width, and color of the left Y-axis. | |
Show Gridlines | Specifies whether to show gridlines on the left Y-axis, including the line style, line width, and color of the left Y-axis. | |
Axis Value Range and Interval |
|
You need to configure Right Y-axis only when Show Dual Y-Axes is selected. The parameter configuration is the same as that of Left Y-axis.
Legend
In the Legend section, specify whether to show the legend and set the legend style.
PC Configuration
Configuration item
Description
Content
When the field in the Category Axis section is the same as the field in the Color Legend section, and Fill with Graphics is enabled in the Drawing Area section, the chart contains multiple legends. You can select the content to be displayed in the legend here.
Position
Set the display position of the legend. The following four legend presentation modes are supported.
Text
Set the legend text style.
Mobile Configuration
Configuration item
Description
Position/Multi-row Equal Division Display
After selecting the Multi-row Equal Division Display mode, you can display measure metrics in multiple rows, for example:
When measure names are long and hidden in the Multi-row Equal Division Display mode, you can use the Show Full Text feature to display them completely, for example:
Position/One-row Tile Display
After selecting this option, you can change the display of measure metrics from multiple rows to one-row tile display.
Metric Display
When a metric is not selected, the display effect is "-" by default. You can switch to the "Empty" display effect.
Data Label
In the Data Label section, specify whether to show data labels and set the label style.
Configuration item | Description |
Show All | Specifies whether to show all data labels. |
Position | Set the display position of labels. When Fill with Graphics is enabled in the Drawing Area section, you can only select Outside the Graphic. |
Text | Set the label text style. |
Tooltip
In the Tooltip section, set the tooltip mode.
Configuration item | Description |
Display Mode | Set the tooltip display mode. Two modes are supported: By Single Data Point and By Dimension Value. |
Content | When the display mode is By Single Data Point, percentage is supported. When the display mode is By Dimension Value, total and percentage are supported. |
Background Color | Set the background color. |
Text | Set the tooltip text style. |
Switch to the mobile layout to control whether to display tooltips on mobile devices.
Series Settings
In the Series Settings section, set the series style.
You need to set aliases and value display formats in Series Settings only when Color Legend (Dim.) is enabled.
Configuration item | Description |
Select Series | The series. You can specify a measure or dimension based on your business requirements. |
Show Data Labels | Specifies whether to show data labels, including label color and position. |
Show Extreme Values | Specifies whether to show the labels of the minimum and maximum values in the line chart. Note This parameter is unavailable in stacked vertical bar charts and 100% stacked vertical bar charts. |
Auxiliary Display
In the Auxiliary Display section, set metric filtering display and scroll bar.
Configuration item | Description |
Enable Metric Filtering Display | Specify whether to enable this feature. After it is enabled, set the default selected metric field.
|
Show thumbnail axis | Set the display mode of the scroll bar.
|
Configure Chart Analysis
Configuration item | Name | Description |
Data Interaction | Drill Down | When you have set up drill-down fields in the field panel, you can set the display style of drill-down hierarchy rows here. |
Linkage | If the data that you want to analyze exists in different charts, you can click the Edit icon next to Linkage and configure the parameters in the Filter Interaction dialog box. Charts can be associated for data analysis. For more information, see Configure and use linkage. | |
Jump | If the data that you want to analyze exists in different dashboards, you can click the Edit icon next to Hyperlink and configure the parameters in the Hyperlink dialog box. Dashboards can be associated for data analysis. Hyperlinks include Parameter Hyperlink and External Link. For more information, see Configure and use hyperlinks. | |
Analysis Alert | Auxiliary Line | An auxiliary line can be used to show the difference between the value of a measure and the reference value indicated by the auxiliary line. The reference value 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 can be used to show the overall trend of the current data. Trendlines are classified into six types: Smart Recommendation, Linear, Logarithmic, Exponential, Polynomial, and Power. For more information, see Analysis alert. | |
Annotation | - | You can use highlighted measures, icons, comments, or data points as labels to mark the data that is abnormal or you focus on in a chart. This helps you identify data exceptions and fix the issue. For more information, see Annotation. |
What to do next
When other users need to view the dashboard, you can share the dashboard with specific users. For more information, see Share a Dashboard.
When you need to create a complex dashboard with navigation menus for thematic analysis, you can integrate the created dashboard into a data portal. For more information, see Create a PC data portal.