# Bar charts Bar charts are commonly used to display and compare data. These are used to show the distribution of data within a set of categories or groups. ### 1. Adding the bar chart Let's start with an example below where we'll visualize the magnitude of sales of the categories using a **solid bar chart.** **Step 1:** We have added 'SubCategory' in the **Rows** field, and 'Sales', 'Margin', 'Margin %', and 'Total Customers' in the **Values (AC)** field in the visualization pane.

**Step 2:** Select the column for which you want to insert the bar chart. In the following image, the 'Sales' column has been selected. The chart options get enabled. From the **Bar chart** drop-down, select the **Solid bar chart**.

**Step 3:** The solid bar chart gets inserted as shown below.

You can see the **Customize** tab in the toolbar with the following chart customization options. ### 2. Customization options Inserting a bar chart will open up the following configuration options. ### 2.1. Chart type Here you can change your current chart type. Inforiver offers five variants of bar charts: **Solid bar, Colored bar, Invert-colored bar, Range bar** and **Square Area bar.**

A **range bar chart** shows the minimum and maximum values of a data point as a bar highlighting the range rather than a single value.

A **square area bar chart** represents values using squares whose area and color reflect the data, making differences easy to compare.

### 2.2. Axis config This option lets you configure the axis for the chart. Clicking on the **Axis Config** option will open up the **Axis modal** in which you can configure the following properties: * **Axis direction** - From this drop-down, you can set the direction of the axis to either 'Left to Right' or 'Right to Left'. * **Row level Scaling** - Using this drop-down you can set the scaling option to 'Universal' or 'By level'. * **Show Y Axis** - Enable this check box if you want to display an axis on the Y coordinate. * **Show X Axis** - Enable this check box if you want to display an axis on the X coordinate. * **Hide ticks** - With this option, you can either show/hide tick intervals.

### 2.3. Reference line Reference lines are horizontal or vertical lines that are added to a chart to indicate a specific value or threshold. Using this option, you can add a reference line for values such as average, median or set a custom value. Clicking on this option will open up a **Reference line** modal to the right of the report.

Click on the **Add New Line** button in the modal. This will open up a toolbar as shown below.

You can customize the following options in the reference line modal: **a) Value display -** This option has two dropdowns. From the first drop-down, you can select the data metric for which you want to display the reference line. And the second drop-down lets you select the value at which the reference line needs to be inserted. You can select from the following values: 1. **Average -** Inserts a reference line at the average value of the data metric 2. **Median - Inserts** a reference line for the median value of the data metric 3. **Standard deviation -** Inserts a reference line for the standard deviation of the data metric 4. **Mid value -** Inserts a reference line at the mid value of the data metric 5. **Constant -** If you select this option, an additional 'Static value' field becomes available. Using this option, you can set the static/constant value at which you want to insert the reference line.

**b) Style -** This option has three dropdowns. From the first drop-down, you can choose the style of the reference line. You can choose from any of the following options: **Dotted***,* **Dashed***,* **Solid***,* **Long Dashed***,* or **Double Solid**. From the second drop-down, you can select the color of the reference line. And from the third drop-down, you can choose the position of the reference line. It has the following two options: *Front* - positions the reference line in front of data values, and *Back* - positions the reference line to the back of the data values.

After choosing all the customizations, click on 'Apply' to insert a reference line with chosen customization options.

**Add more than one reference line** - To add more than one reference line, you can click on the 'add new trend line' link at the bottom of the toolbar in the reference line modal.

**Delete a reference line** - To delete an existing reference line, click on the trash can/delete icon.

**Disable a reference line** - To disable an existing reference line, click on the toggle switch button.

### 2.4. Reference band Reference bands are similar to reference lines, but they are represented as a shaded area between two lines. They are used to indicate a range of values. Clicking on this option will open up a **Reference Band** modal.

From this modal, you can customize the following options **a) Value Display -** This option has two dropdowns. From the first drop-down, you can select the data metric for which you want to display the reference band. And the second drop-down lets you select the ending value of the reference band. You can select from the following options: 1. **Average -** The average value of the data metric is set as the ending value of the reference band 2. **Median -** The median value of the data metric is set as the ending value of the reference band 3. **Standard deviation -** The standard deviation of the data metric is set as the ending value of the reference band 4. **Mid value -**The mid value of the data metric is set as the ending value of the reference band 5. **Constant -** If you select this option, an additional 'Static Value' field becomes available. Using this option, you can set the static/constant value which is set as the ending value of the reference band.

**b) Start From -** Using this drop-down, you can select the starting value of the reference band. It has the following options: 1. **Min** - The minimum value of the data metric becomes the starting value of the reference band 2. **Zero** - Zero becomes the starting value of the reference band

3**. Constant** - If you select this option, a new input field becomes available where you can select the constant value which becomes the starting value of the reference band.

**c) Line Style -** The line style option allows you to set the style and color of the lines that get displayed at the starting and ending value of the reference band. From the first drop-down, you can choose the style of the lines. You can choose from the following options: **Dotted**, **Dashed**, **Solid**, **Long Dashed**, and **Double Solid**. And, from the second drop-down, you can select the color of the lines.

**d) Background color** - This color picker lets you choose the color for the shaded area in the reference band. **Delete reference band** - To delete an inserted reference band, click on the 'Delete' button at the bottom of the 'Reference Band' modal.

### 2.5.Comparison band In case of **Solid Bar**, the comparison band indicates the state of the measure depending on which band it resides in. They provide a performance rating to the value being measured where each color represents a different state.

You can add comparison bands by clicking on the 'Comparison bands**'** icon. The following properties are available: * **Compared series** - This drop-down lets you configure the range of comparison bands as values or percentages. * **Dynamic** - If you enable this checkbox, then the comparison band range will be added based on individual scaling.

* **Number of bands** - Here you can set the number of bands required. * **Flip** - Enable this toggle to reverse the color order.

### 2.6. Data label config This option lets you configure the properties related to the data label. You can configure the following properties: * **Data label -** This checkbox lets you show/hide data labels. Note that other options become available only if this option is enabled. * **Bar overlap** - By enabling this option, you can overlap the data labels over the bar. By default, this option is not enabled, and the data labels are displayed next to the corresponding bar. * **Data label flip** - With this option, you can reverse/flip the positions of the data labels. By default, the labels are placed to the right of the bar. By enabling this option, you can flip/reverse their position to the left with respect to the bars.

* **Show label** - In this drop-down, you can select the format of the data label. You can display the data values as just **Value (numbers)**, as **Percentage**, or as **Both**. * **Percentage scaling** - This drop-down gets enabled only if you have chosen 'Percentage' or 'Both' as the data format in the show label drop-down and when the chart contains hierarchical levels. Using this option, you can configure the scaling of the percentage data label. The available scaling options are 1. **Universal - This** is the default option, and it indicates the percentage contribution of the value to the grand total. 2. **By level -** Whereas 'By level' indicates the percentage contribution of the value to its parent level or category.

{% hint style="info" %} Bar Overlap and Data Label Flip are not applicable for Square Area Bar {% endhint %} ### 2.7. Padding You can configure the inner padding (the space between the bar and the top/bottom border of a cell) with this option. Increasing the padding value will increase the spacing.

### 2.8. Fill pattern You can customize the fill pattern to any of these IBCS notations: **Solid***,* **Outlined***,* or **Hatched**.

{% hint style="info" %} Fill Pattern is not applicable for Square Area Bar {% endhint %} ### 2.9. Appearance Appearance lets you define properties such as the bar color, axis color, data label color, etc. {% hint style="info" %} Some of these properties/options may or may not be available depending on the inserted chart type and variant. {% endhint %} **Colors** The following options can be accessed by clicking on the **Colors** option.

**a) Positive color** - Using this option you can customize the positive color of the bar/marker **b) Negative color** - Using this option you can customize the negative color of the bar/marker **c) Axis color** - This option lets you set the axis color of the chart **d) Data label color** - This option lets you set the color of the data labels in the chart **e) Bar color** - This option is available only for solid bar charts and will let you customize the color of the bar

**f) Gradient** - In case of **Solid bar** enabling this option will allow you to set a gradient color to your bar chart. If you enable this option, the Min and Max color options become available using which you can set the color for the min value and the max value.

### 2.10. Break Bar In the case of a **Range bar** chart, this option lets you break the range bar into segments based on the given breaks.

When you use the **Break Bar** option, the **Breaks** option is automatically enabled. You can use the arrows in the **Breaks** option to increase or decrease the number of breaks. ### 2.11. Grid Display In the case of a **Square Area bar** chart, this option lets you change the number of grids to 5x5 or 10x10.

### 2.12. Height Scaling This option lets you customize the height scaling(width) of the bars in the bar chart. By default, **Individual Scaling** is applied. **a) Individual** - Using this option you can set the height scaling based on each row.

**b) Universal** - Using this option you can set height scaling based on the parent level.

### 2.13. Measure Scaling This option lets you select the measure scaling of the chart. By default, **Universal** **Scaling** is applied. **a) Universal** - In this option the scaling of the chart is fixed based on the consolidated min and max values from all the measures. For reference the consolidated min value is '13.05' and max value is '778.51' from all the measures, therefore the scaling of the chart is fixed based on these values.

**b) Individual** - In this option the scaling of each individual measure is fixed based on their own Min and Max values.

--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.inforiver.com/working-with-inforiver/6.-working-with-charts/bar-charts.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.