Advanced Bar Chart Widget
This widget belongs to the Dashboards category in the widget library. It enables you to view, for a given measure, each dimension element using horizontal bars whose length is proportionate to the value of the data represented.
You can use numerous properties to format the chart, e.g. display and format the chart title and axes, define the position of the legend, use the color palette, format axis labels, display tooltips, etc.
Examples
CSV file data
- Dimension = 6 weeks
- Measure = Number of incidents
- Elements displayed: Number of incidents per working day over the past 6 weeks
Note: The data source contains several measures. You select the measure you want (working days in the week) using the Data Transformer.
Download
Different chart displays for the number of incidents per week
| Individual bars - Dimension labels displayed diagonally - Tooltips | Measures stacked in percentages - Values displayed for each dimension |
|---|---|
 |
 |
Notes
- The number of bars is identical to the number of dimension elements. Each bar is displayed in a different color indicated in the legend.
- Measures can be stacked (aggregated values) or clustered (individual values).
- The scale of the measure axis can be defined manually. By default, it starts at 0 and continues up to the maximum value of the selected measures.
- The legend can be used as a dynamic data filter in execute mode. To use it, click the label.
Best practice
- Use this widget when dimension elements contain data that you want to compare.
- To display a time series, you should use the Advanced Line Chart widget.
- If you want to highlight the distribution of values instead of the total value, you should use stacked bars. The total of each bar is equal to 100%. The values within each bar represent percentages.
- Select the measures you want using the Data Transformer. If you do not do so, they will all be included.
Note: If your data source contains numerous measures and dimensions, your chart will be difficult to read. If this is the case, you should only select the most important measures. - To improve the readability of different ranges within the measure axis, you can increase the height of the widget.
List of properties
Content
DataSource
Data Source: External data source associated with the widget.
- The drop-down list displays all of the data sources available in the app.
- To modify the data source or to view its contents, you should click
. The 
button below the Preview property shows the number of rows (max. 15) and columns extracted. - To define a new data source, click
Add Data Source in the Objects pane.
DataTransformer
Data Transformer: Used to define the structure and scope of the data source, apply statistical aggregate functions and modify the order of the measures displayed.
- Click Setup / Preview Data below the Data Transformer property to open the dedicated window.
See the description.
EnableDrilldown
Enable Drilldown (Note: Only for an EasyVista data source data source using a view with grouping levels): Used to indicate if data is aggregated (box is checked - the drill-down functionality is enabled) or not (box is not checked).
example Breadcrumbs widget: Breakdown of equipment by location.
- If you want the widget to display the breakdown in a grouping level, you should not check this box.
- Add a Breadcrumb widget to facilitate navigation within grouping levels.
Data
SortByValueDescending
Sort By Value Descending: Used to sort dimension elements in descending order (if the box is checked, from highest to lowest value) or in the order in which they are read in the data source (box is not checked). Note: The order applied is determined by the dimension elements of the first measure in the data source.
example You want to display the chart for incidents and requests per employee
The data source contains the Department dimension with three elements. 
| Box is checked | Box is not checked |
|---|---|
|
The dimension elements of each measure are sorted in descending order. |
The dimension elements of each measure are displayed according to the sort order of the data source. |
FirstRowContainsDimensionElements
First Row Contains Dimension Elements: Used to specify the structure of the data source by indicating if dimension elements are found in the first column (box is not checked: standard data source structure) or in the first row (box is checked). Note: This property does not affect the behavior of the Data Transformer.
MaximumNumberOfData
Maximum Number Of Data: Used to indicate the maximum number of dimension elements to be loaded from the data source for each measure selected in the data source.
You should use this property to prevent loss of performance when data volume is large.
- The count is always performed from the first dimension element.
- When the number of dimension elements to be loaded is greater than the number of dimension elements in the data source, all of the data is loaded.
- To view the data source, click next to the Data source property, then click button below the Preview property which shows the number of measures and the number of dimension elements for each measure.
example You want to display the chart for incidents and requests per employee
The data source contains the Department dimension with three elements.
|
|
|
|---|---|---|
|
All dimension elements are loaded and displayed for each measure, i.e. the three departments. |
Only the first two dimension elements are loaded and displayed for each measure, i.e. the first two departments. |
All dimension elements are loaded but only the first element is displayed. This corresponds to the Sales department. The Others dimension element groups values from the Marketing and Administration departments. |
MaximumNumberOfDisplayedData
Maximum Number Of Displayed Data: Used to indicate the maximum number of dimension elements to be displayed for each measure selected in the data source. This improves chart readability.
example You want to display the chart for incidents and requests per employee. See the Maximum Number Of Data field.
- The count is always performed from the first dimension element.
- When the number of dimension elements to be displayed is less than the number of dimension elements to be loaded, the Others dimension element will automatically be added to the chart. It will aggregate all of the values from non-displayed dimension elements.
Charts
AdvancedDashboards_Charts_3Dimensions
3D: Used to indicate if the chart should be displayed in 3D with an impression of depth (box is checked) or in 2D (box is not checked).
AdvancedDashboards_Charts_StackedView
Stacked View: Used to indicate if the measure values of each dimension element should be stacked one on top of the other (box is checked) or not (box is not checked). If you want them to be stacked, you should specify the display in the Stacked Mode list.
Stacked Mode: Display of stacked values.
- Normal: Measures are displayed in raw values.
- The maximum value of the scale is equal to the highest total value of measures for dimension elements.
- Percent: Measures are displayed in percentages based on the total value of the dimension element.
- The scale will range from 0 to 100.
- All bars will have the same maximum height of 100.
| Individual values (box is not checked) | Stacked values (box is checked) | |
|---|---|---|
| Raw values
(Stacked Mode = Normal) |
Total values = 100%
(Stacked Mode = Percent) |
|
 |
 |
 |
X Axis
AdvancedDashboards_XAxis
Axis Position: Position of the dimension axis. Note: The name of the axis is also affected by the position.
- Top: The axis is placed at the top of the chart and the name appears above the axis.
- Bottom: The axis is placed at the bottom of the chart and the name appears below the axis.
| Name above the axis (Top option) | Name below the axis (Bottom option) |
|---|---|
 |
 |
Axis Color (Inherit): Color of the dimension axis.
Tickmarks Color (Inherit): Color of tickmarks in the dimension axis.
Display Axis Name: Used to indicate if the name of the dimension axis should be displayed (box is checked) or not (box is not checked). If you want to display it, you should enter the title in Axis Name.
- The name appears above or below the chart depending on the value specified in Axis Position.
| Axis name displayed above the chart (box is checked and Axis Position = Top) | Axis name displayed below the chart (box is checked and Axis Position = Bottom) |
|---|---|
 |
 |
Display format of the axis name: e.g. font, background color, text color, etc.
PageGeneralFormat
| Font Family (Inherit) | Font of the text, selected via Select Font |  |
|
| Size | Font size, selected via the slide or specified directly in the field | ||
| Alignment (Inherit) | Alignment of the text (Left/Center/Right/Justified) | ||
| Style (Inherit) | Font style of the text Bold/Italic/Underline) | ||
| Background Color (Inherit) | Background color of the widget | ||
| Text Color (Inherit) | Color of the text displayed by the widget
Note: Priority is given to the font and color defined using the text editor |
X Axis Label
AdvancedDashboards_XAxisLabel
Display Axis Label: Used to indicate if the measure axis labels should be displayed (box is checked) or not (box is not checked). The labels are from the data source.
- Define the display format using the properties below.
Stagger Mode (Note: Only if the Display Axis Label box is checked): Based on the device size, e.g. smartphone, tablet, etc., certain labels may be omitted in order to display a single row. To display all labels over two rows, you can stagger them by checking this option.
| Display in one row (box is not checked) | Staggered display over two rows (box is checked) |
|---|---|
|
Note: To display all labels in a single row, you can also:
|
Label Length (Note: Only if the Display Axis Label box is checked): Used to indicate if the dimension axis labels should be truncated (box is checked) or not (box is not checked). If you want to truncate them, you should enter the number of characters for each label in Truncate Value.
| Truncated labels (box is checked and Truncate value = 4) | Non-truncated labels (box is not checked) |
|---|---|
 |
Note: The Is Rotate property is enabled. |
Is Rotate (Note: Only if the Display Axis Label box is checked): Used to indicate if the dimension axis labels should be rotated (box is checked) according to the angle defined in Rotate Value or if they should be displayed horizontally (box is not checked).
- A negative value rotates text to the right.
- A positive value rotates text to the left.
- When the value is zero, labels are not rotated.
PageGeneralFormat
| Font Family (Inherit) | Font of the text, selected via Select Font | |
|
| Size | Font size, selected via the slide or specified directly in the field | ||
| Alignment (Inherit) | Alignment of the text (Left/Center/Right/Justified) | ||
| Style (Inherit) | Font style of the text Bold/Italic/Underline) | ||
| Background Color (Inherit) | Background color of the widget | ||
| Text Color (Inherit) | Color of the text displayed by the widget
Note: Priority is given to the font and color defined using the text editor |
X Lines
AdvancedDashboards_XLines
Display Lines: Used to indicate if horizontal gridlines should be displayed (box is checked) or not (box is not checked). These horizontal gridlines are parallel to the dimension axis.
- Note: The display of gridlines improves chart readability. In 3D charts, gridlines are displayed in depth.
- You can modify the color of gridlines in Color.
Y Axis
Left Axis
AdvancedDashboards_YLeftAxis_AxisPosition
Axis Position: Position of the measure axis.
Note: The name of the axis is also affected by the position.
- Left: The axis is placed to the left of the chart and the name appears to the left of the axis.
- Right: The axis is placed to the right of the chart and the name appears to the right of the axis.
| Name left of the axis (Left option) | Name right of the axis (Right option) |
|---|---|
 |
 |
AdvancedDashboards_YLeftAxis
Min Value: Minimum start value of the scale of the measure axis.
- By default, the scale will start with the lowest value in the data source, rounded down to the nearest tenth.
22 ==> 20
Max Value: Maximum end value of the scale of the measure axis.
- By default, the scale will end with the highest value in the data source, rounded up to the nearest tenth.
42 ==> 50
| Default values | Values specified manually (min = 27; max = 45) |
|---|---|
 |
 |
Axis Color (Inherit): Color of the measure axis.
Tickmarks Color (Inherit): Color of tickmarks in the measure axis.
Display Axis Name: Used to indicate if the name of the measure axis should be displayed (box is checked) or not (box is not checked). If you want to display it, you should enter the title in Axis Name.
- The name appears to the left or right of the chart depending on the value specified in Axis Position.
| Axis name displayed left of the chart (box is checked and Axis Position = Left) | Axis name displayed right of the chart (box is checked and Axis Position = Right) |
|---|---|
 |
 |
Display format of the axis name: e.g. font, background color, text color, etc.
PageGeneralFormat
| Font Family (Inherit) | Font of the text, selected via Select Font | |
|
| Size | Font size, selected via the slide or specified directly in the field | ||
| Alignment (Inherit) | Alignment of the text (Left/Center/Right/Justified) | ||
| Style (Inherit) | Font style of the text Bold/Italic/Underline) | ||
| Background Color (Inherit) | Background color of the widget | ||
| Text Color (Inherit) | Color of the text displayed by the widget
Note: Priority is given to the font and color defined using the text editor |
AdvancedDashboards_YLeftAxis_DataType
Data Type: Used to define the display format of values in the measure axis and in tooltips (Common > Tooltip section). Note: The number format, e.g. comma or period for the decimal symbol, depends on the configuration settings of the platform used by the logged-in user. In Windows, this is specified in the Control Panel > Regional and Language Options.
- Integer: Whole numbers rounded up or down to the nearest unit.
152200.87 ==> 152201
- Float: Values with 2 decimals
152200.87 ==> 152200.87
Left Axis Label
AdvancedDashboards_YLeftAxisLabel
Stagger Mode (Note: Only if the Display Axis Label box is checked): Based on the device size, e.g. smartphone, tablet, etc., certain labels may be omitted in order to display a single column. To display all labels over two columns, you can stagger them by checking this option.
| Display in one column (box is not checked) | Staggered display over two columns (box is checked) |
|---|---|
 |
Note: To display all labels in a single column, you can rotate them using the Is Rotate property. |
Is Rotate: Used to indicate if the measure axis labels should be rotated (box is checked) according to the angle defined in Rotate Value or if they should be displayed horizontally (box is not checked).
- A negative value rotates text to the bottom.
- A positive value rotates text to the top.
- When the value is zero, labels are not rotated.
Prefix: Alphanumeric value added to the start of each label in the measure axis.
Labels preceded by the measure unit
- Prefix = M
- Label = 150
==> value displayed: M 150
Suffix: Alphanumeric value added to the end of each label in the measure axis.
Labels ended with the measure unit
- Suffix = K
- Label = 150
==> value displayed: 150 K
PageGeneralFormat
| Font Family (Inherit) | Font of the text, selected via Select Font | |
|
| Size | Font size, selected via the slide or specified directly in the field | ||
| Alignment (Inherit) | Alignment of the text (Left/Center/Right/Justified) | ||
| Style (Inherit) | Font style of the text Bold/Italic/Underline) | ||
| Background Color (Inherit) | Background color of the widget | ||
| Text Color (Inherit) | Color of the text displayed by the widget
Note: Priority is given to the font and color defined using the text editor |
Y Lines
AdvancedDashboards_YDisplayLines
Display Lines: Used to indicate if vertical gridlines should be displayed (box is checked) or not (box is not checked). These vertical gridlines are parallel to the measure axis.
- Note: The display of gridlines improves chart readability. In 3D charts, gridlines are displayed in depth.
- You can modify the color of gridlines in Color.
Common
AdvancedDashboards_Common_General
Animation: In execute mode, this is used to indicate if the chart should be displayed in dynamic mode (box is checked) or in static mode (box is not checked). In dynamic mode, elements are displayed one after the other while in static mode, they are displayed at the same time.
AdvancedDashboards_Common_DisplayPrintExportButton
Display Print and Export Button: Used to indicate if users can save and print the chart (box is checked) or not (box is not checked). If users can save and print it, the 
and 
icons will appear. Note: The icons are always displayed to the right of the chart.
- : Used to save the chart in a JPG file.
- : Used to print or save the chart in a PDF file.
AdvancedDashboards_Common_DisplayAreaColor
Display Area Color: Used to indicate if a specific color should be applied to the background (box is checked) or not (box is not checked). If you want a background color, you should select it in Chart Area Color.
- The area of the background is delimited by the dimension axis and the measure axis.
- To apply a background color to the entire chart, use the Theme > Background Color property. The background color defined in the Display Area Color property will have priority.
| Background color defined (box is checked) | White background (box is not checked) | Background color for the entire chart (Theme property) |
|---|---|---|
 |
 |
 |
Title
AdvancedDashboards_Common_DisplayChartTitle
Display Chart Title: Used to indicate if a title should be added to the chart (box is checked) or not (box is not checked). If you want to add a title, you should enter it in Chart Title and define its format.
Display format of the chart title: e.g. font, background color, text color, etc.
PageGeneralFormat
| Font Family (Inherit) | Font of the text, selected via Select Font | |
|
| Size | Font size, selected via the slide or specified directly in the field | ||
| Alignment (Inherit) | Alignment of the text (Left/Center/Right/Justified) | ||
| Style (Inherit) | Font style of the text Bold/Italic/Underline) | ||
| Background Color (Inherit) | Background color of the widget | ||
| Text Color (Inherit) | Color of the text displayed by the widget
Note: Priority is given to the font and color defined using the text editor |
Labels Points on the Graph
AdvancedDashboards_Common_DisplayPointLabel
AdvancedDashboards_Common_DisplayPointLabel_WithoutPosition
Display Point Label: Used to indicate if data labels in the chart should be displayed (box is checked) or not (box is not checked). If you want to display data labels, select the information to be displayed from the Label list.
- By default: Value of the dimension axis followed by the value of the measure axis.
- Define the display format, e.g. font, background color, text color, etc.
Label (Note: Only if the Display Point Label box is checked): Information displayed in the chart.
- Name: Values of the dimension axis.
- Value: Values of the measure axis.
- Click x to return to the default option where the two values are displayed.
| Default display | Values of the dimension axis
(Name option) |
Values of the measure axis
(Value option) |
|---|---|---|
 |
 |
 |
Display format of the data labels: e.g. font, background color, text color, etc.
PageGeneralFormat
| Font Family (Inherit) | Font of the text, selected via Select Font | |
|
| Size | Font size, selected via the slide or specified directly in the field | ||
| Alignment (Inherit) | Alignment of the text (Left/Center/Right/Justified) | ||
| Style (Inherit) | Font style of the text Bold/Italic/Underline) | ||
| Background Color (Inherit) | Background color of the widget | ||
| Text Color (Inherit) | Color of the text displayed by the widget
Note: Priority is given to the font and color defined using the text editor |
AdvancedDashboards_Common_DisplayPointLabel_WithoutPositionEnd
Position: Position of data labels in the chart.
- Inside the Chart: Within the chart.
- Outside the Chart: Outside the chart. You should use this option when information tends to overlap within the chart. This will provide more space for longer data labels.
| Within the chart (Inside option) | Outside the chart (Outside option) |
|---|---|
 |
 |
Color Palette
AdvancedDashboards_Common_ColorPalette
Chart Color: Color palette applied to the chart. This is used to define the color of chart data and the color of legend buttons.
- The list is provided by
. - The number of colors in the palette is indicated next to its name, e.g. Brown (6), Default (12), EasyVista (7).
- The color of other chart elements, e.g. axis title and labels, chart title and tickmarks, are defined using specific properties.
Legend
AdvancedDashboards_CommonLegend
AdvancedDashboards_CommonLegend_DisplayTitle
Display Legend: Used to indicate if the chart legend should be displayed (box is checked) or not (box is not checked).
- Each legend is made up of the name of the dimension element preceded by a button.
- The color of the buttons is defined by the color palette applied to the chart (Common > Color Palette property).
- Define the position of the legend using the Layout, Position, Horizontal and Vertical properties. Caution: Depending on the selected options, the chart will automatically be resized to allow legends to be fully displayed.
- Note: The legend can be used as a dynamic data filter in execute mode. When you click a button or name, you can display or hide the corresponding values in the chart.
Display Legend Title (Note: Only if the Display Legend box is checked): Used to indicate if a title should be added above the chart legend (box is checked) or not (box is not checked).
AdvancedDashboards_CommonLegend_DisplayTitleEnd
Layout (Note: Only if the Display Legend box is checked): Orientation of the chart legend.
- Horizontal: Legend labels are displayed horizontally, adjacent to each other.
- Vertical: Legend labels are displayed vertically, one below the other.
| Legend in rows (Horizontal option) | Legend in columns (Vertical option) |
|---|---|
 |
 |
Properties for the legend position (Note: Only if the Display Legend box is checked).
Click to see the summarized layouts.
- Vertical alignment (Layout = Vertical)
- Horizontal alignment (Layout = Horizontal)
Position: Position of the legend within the chart.
- Top: At the top of the chart.
- Bottom: At the bottom of the chart.
- Left: To the left of the chart.
- Right: To the right of the chart.
Horizontal Align (Note: Only if Position = Top or Bottom): Horizontal position of the chart legend.
- Left: To the left of the chart.
- Center: In the center of the chart.
- Right: To the right of the chart.
Vertical Align (Note: Only if Position = Left or Right): Vertical position of the chart legend.
- Top: At the top of the chart.
- Center: At the top of the chart.
- Bottom: At the bottom of the chart.
Tooltip
AdvancedDashboards_CommonTooltip
Display Tooltip: Used to indicate if data labels should be displayed in a tooltip when the cursor hovers over the chart (box is checked) or not (box is not checked). If you want to display tooltips, select the information to be displayed from the Label list.
- Information displayed by default when the cursor hovers over each data point: Value of the dimension axis / Value of the measure axis
- Define the display format using the properties below.
Tooltip Display Mode (Note: Only if the Display Tooltip box is checked): Used to define the information displayed when the cursor hovers each data point.
- Single: Value of the dimension axis / Value of the measure axis
- Union: Value of the dimension axis / All values of the measure axis
| Current value of the measure axis (Single option) | All values of the measure axis (Union option) |
|---|---|
 |
 |
Position (Note: Only if the Display Tooltip box is checked): Position of the data point's tooltip based on the movement of the cursor.
- Float: The tooltip will move along with the cursor.
- Point: The tooltip always appears above the data point regardless of the position of the cursor.
Theme
See the description of properties.