A bar chart or bar graph is a chart that presents grouped data with rectangular bars with lengths proportional to the values that they represent. The bars can be plotted vertically or horizontally. A vertical bar chart is sometimes called a column bar chart. In VitaraCharts, users will separate icons for horizontal and vertical charts and users will need to switch as needed.
Metrics - 1 or more metrics Attributes - 1 or more attributes Use as Filter Option - Available
In the business point of view, certain part of the chart needs to be highlighted to draw more attention from the desicion makers. For example, highlight the stores where total sales is greater than a specific value or highlight the top 10 products whose sales is high during last year’s winter. Thresholds are very useful objects in these use cases.
Thresholds will display some conditional formatting in a chart to highlight certain data points depending on predefined criteria.The criteria are attribute or metric qualifications. If a qualification’s expression evaluates to TRUE, the report displays the threshold. We can also include markers in thresholds.
To apply thresholds in vitara charts, hover the cursor on the chart. Vitara chart will display an ‘Edit’ button. When you click on this ‘Edit’ button the properties window will pop out. Select the thresholds tab to open threshold editor. In the window you can add a new threshold or delete any existing threshold or modify the existing threshold.
Note: From 4.6 version we can apply thresholds using attributes. The source drop down box in the threshold editor window will list all the attributes and metrics in the chart. we can select an attribute as source and define a threshold condition. The target of the threshold depends on the series of the chart. This means, if the chart series is created using metrics then target drop down box will display the metrics. If we enabled ‘color by’ mode, by adding an attribute to the ‘color by’ drop zone in the dossier’s editor panel, the chart series will be created using attributes. In this case the threshold target drop down box will show all the elements of attribute used in the color by drop zone. In this case we can set threshold target using attribute.
In the threshold, the editor window apply source, target, threshold condition and the other related information to set a threshold on the chart.
Apply all the inputs and click on ‘Apply’ button.
From version 4.9.0, we can use pattern fill in thresholds, certain part of the chart can be filled with a pattern.
You can do both Category and Value formattings, by using Title, Label, Axis line and other options in the property editor.
Example of text formatting and color formatting for labels, title and axis line in the column chart.
From 4.1 version, a new property is introduced in bar and column charts to show the data labels outside the bar/column. The option to enable this feature is added in data labels tab with ‘Show Label Outside Bar/Column’ checkbox. See the screenshot below:
By default, this option will be enabled for the charts created from 4.1. Below screenshot shows how the data labels look before and after enabling ‘Show Label Outside Bar/Column’ option
‘Show Label Outside Bar/Column’ feature is linked with horizontal data label positions. If data label is set to be shown outside the bar/coulmn, then the horizontal data label positions right, left, center will not have any effect on the chart.
From 4.7 version of VitaraCharts, a new property called ‘Force Outlier Labels Outside’ is added in all charts that will have bars as series. With this property, the data labels will be forced to display outside the bar even if the bar has the maximum value in the chart.
See the screenshot for Bar chart before and after
We can turn the bar/column chart into the combinational chart by changing the ‘series type’ in the ‘series’ tab.
From version 4.9.0, this charts have the Pattern fill option (Grid/Square/Double Square/Slash) in the Series tab, which allows us to display data in a more presentable manner.
From Version 5.1.1, we have added a new feature that allows us to add markers to bar and column charts using image addresses (links). This functionality can be enabled under the series tab with name ‘Set DataMarker (link),’ where we must enter the URL and press the Apply button.
From 4.6 version, the Bar/Column charts as they support Series as Line/Area use the updated marker properties. Open the property editor by clicking on the ‘Edit’ button and select the Series tab you can see the Enable marker, Marker type and Marker size options to Enable marker properties. Below are the screenshots with the marker options.
In the below example, the bar changed to line in series property and ‘Thumbs-up’ marker is applied for the ‘2015 Q2’ attribute element. Below is the screenshot with the marker applied in the chart.
From Version 5.1.1, we added a new feature for adding data markers. The dataset must include a column that contains tags or links since these markers will be activated by html tags or links from attribute forms. The markers will automatically display on the chart as soon as this column is included in the attribute form.
Below you will find URL dummy dataset created for further explaination:
Now, when dataset is being added we have to follow certain steps:
First, change the ‘Category URL’ datatype to URL or HTML tags as shown below:
The next step is to create a multi-form attribute using two columns, that can be combined using the Ctrl key, as shown below:
Now ,the merged column will show up like this we can now update the changes.
Finally, add attributes and metrics to the chosen dropzones to see markers appear on the charts.
From 4.5 version of Vitara charts, there is a new property named ‘Column’ in column chart and ‘Bar’ in bar chart. You can see properties like Overlay Bar/Column, Bar/Column width, Bar/Column spacing and Series Border Properties. Below is the screenshot of the Bar/Column property editor
From 4.6 version of Vitara charts, there are two enhancements to the Bar/Column chart.
Variwide chart can be used to visualize a second dimension in a column chart. Each data point is given a weight, in addition to its value, determining the width of the column. It computes the width for the stack to fill the whole plot area, and simply lets the column widths reflect a value.
For more details about the Variwide feature please refer to vari_wide.
In polar mode, the Bar/Column charts will use a radial value axis. This way of using axes is called Polar coordinate system.
Let’s see how to use polar coordinates in simple steps.
Create a Bar chart with a minimum of one attribute and one metric. See the sample screenshot below.
Open the property editor and go to the ‘Bar’ tab. Enable the checkbox ‘Enable Polar Mode’. See the screenshot.
Then the value axis of the chart will be converted into Polar coordinates. Below screenshot shows the default behaviour of the chart with Polar coordinates.
Polar Mode settings
Polar mode comes up four settings which include Start angle, end angle, Outer Pane Size, Inner Pane Size.
The default settings of Polar mode are
Start Angle: 90, End Angle: 360, Outer Pane Size: 85, Inner Pane Size:20.
We can modify these settings anytime according to our preference. Let’s see some of the settings below
Start angle : 180
End angle : 90
Outer Pane Size : 90
Inner Pane Size : 20
Then chart looks like the below screenshot
All the axes settings available for normal Bar chart are also applicable to Polar coordinate system
From 4.7 version of VitaraCharts, ‘Variance/Delta’ feature is added in Bar/Column charts just like in IBCS charts. To use this feature, the chart should be created with at least 2 metrics and an attribute
The options to enable this feature are available in the Bar/Column tab of the property editor. See the screenshot below
We have ‘Absolute variance’ and ‘Relative variance’ of which either one of them or both can be enabled at a time according to the requirement.
To enable Absolute Variance, enable ‘Absolute Variance’ checkbox in Bar tab of the property editor. We can also set a title for absolute variance graph
See the screenshot below:
To enable Relative Variance, enable ‘Relative Variance’ checkbox in the Bar tab of the property editor. We can also set a title for relative variance graph
See the screenshot below:
We can also enable both the absolute and relative variances at once. And the chart looks like in the below screenshot:
Play by - animation shows the chart for each element of the first attribute. For more details about the play by feature please refer to play-by.
The steps to set a background image for all Vitara charts are explained in backgroundImage.
Bar/Column chart supports small multiples feature. Small multiples feature is explained in smallMultiples.
From the version 4.4, data markers feature is introduced in the Bar/Column charts. To know about Data Markers feature please click Here.
From version 5.0, the Bar Chart can now show fill percentage, where the fill is displayed as a percentage of the attribute and the remaining space is left empty.
We can enable this feature by going to the Bar tab.
We can set the Max value for ‘Auto’ or ‘Fixed’ or the metrics you’ve taken.
We can specify a value for ‘Fixed.’
Once the maximum value is set, we can also add an unfilled color.
Here is a screenshot of a bar fill using a percentage dataset.
From version 5.0, Delta Bar/Column feature added to chart, which can be enabled by selecting options from the series tab for individual series.
There are also options to enable delta Labels, set delta Bar width, and invert delta Bar colors.
The delta Bar feature completely disables error bars and vice versa.
The image below shows how the Profit of the financial years 2020 and 2021 will be compared, showing both negative and positive deltas.
This feature is also available with small multiples and bar variance properties.
DeltaBar has been disabled for Bar Fill, Polarmode, Dynamic width, Overlay, IBCS view & Play-Axis, and colour by.
From version 5.0, Gradient color fill can be added where the series property is available.
It can be enabled by selecting options from the series tab for individual series.
It will show the color palette, which will have two selection handles to choose two colors that will render from beginning to end on the series. (From left to right)
In Version 5.1.1.010, we included a new feature that allows users to show zero value bars. This feature can be enabled under the “Bar” tabs, where it can be used to display metrics, whose values are zero.