# Bullet charts and clustered bar charts Performance chart types are used to visually compare multiple measures in dashboard and scorecard applications, where space is limited, and the goal is to present a lot of data in a small, easy-to-read format. Inforiver provides *2 value bullet charts, 3 value bullet charts,* and *clustered bar charts.* ## 1. Adding the chart ### **i) 2-value bullet charts** These charts are used to compare the performance of *two measures*. Currently, Inforiver offers six variants of 2-value bullet charts. They are * IBCS bullet * Integrated variance bar * Overlapped bar * Conditional bar * Comparative bullet * Stephen Few's bullet In this example, we have 2022 Actuals and Plan across regions and categories and we want to visualize using a 2-value bullet chart. a) We have added '2022 Actuals' in the 'Values (AC)' field and '2022 Plan' in the ' Compare to Prior Period (PY)' field in the visualization pane.

b) Select the columns for which you want to insert a 2-value bullet chart. In the following image, the 2022 Actuals and 2022 Plan columns have been selected. The bullet/stacked chart option gets enabled. From the 'Bullet/Stacked chart' drop-down, select the 'Integrated variance bar chart'.

b) The chart gets inserted showing the comparison of the two measures. The variance between actuals and plan is shown in red/green. You can see the 'Customize' tab in the toolbar and the following [customization options](#2.-customization-options).

Inserting an integrated variance bar chart

### **ii) 3-value bullet charts** These charts are used to compare the performance of *three measures.* Currently, Inforiver offers the following 3-value bullet chart types. * Integrated variance overlap * Integrated bar with marker * Qualitative bullet marker * Conditional bar with marker * Comparative bullet * Bullet with marker In this example, we have 2022 Actuals, 2022 Plan, and 2021 Actuals across regions and categories and we want to visualize using a 3-value bullet chart. a) We have added '2022 Actuals' in the 'Values (AC)' field, '2021 Actuals' in the ' Compare to Prior Period (PY)' field, and '2022 Plan' in the 'Compare to Plan (PL)' field in the visualization pane.

b) Select the columns for which you want to insert a 3-value bullet chart. In the following image, the 2022 Actuals, 2021 Actuals, and 2022 Plan columns have been selected. The bullet/stacked chart option gets enabled. From the 'Bullet/Stacked chart' drop-down, select the 'Bullet with marker chart'.

c) The chart gets inserted displaying the comparison band. The legend is highlighted below. You can see the 'Customize' tab in the toolbar and the following [customization options](#2.-customization-options).

### iii) Clustered bars The clustered bar chart makes it easier to compare multiple measures and is applicable only when using one of these 4 bullet variants: * Stephen Few's qualitative bullet * Qualitative bullet with marker * Comparative bullet * Bullet with marker {% hint style="info" %} A clustered bar chart is applicable only if any of the *Actual, Target,* or *Additional target* types are set to 'Bar'. {% endhint %} In this example, we have 2022 Actuals, 2022 Plan, and 2021 Actuals across regions and categories and we want to visualize using a Clustered bar chart. a) We have added '2022 Actuals' in the 'Values (AC)' field, '2021 Actuals' in the ' Compare to Prior Period (PY)' field, and '2022 Plan' in the 'Compare to Plan (PL)' field in the visualization pane.

b) Select the columns for which you want to insert a clustered. In the following image, the 2022 Actuals, 2021 Actuals, and 2022 Plan columns have been selected. The bullet/stacked chart option gets enabled. From the 'Bullet/Stacked chart' drop-down, select the 'Bullet with marker chart'.

c) A bullet with marker chart gets inserted.

d) To display a clustered bar chart, click on the **'**Series display**'** option under the 'Customize' tab. In the 'Serial Display' modal that opens up, enable the 'Clustered bar' check box and set the 'Target' and 'Additional target' types as 'Bar'. This displays the clustered bar as shown in the below image.

## 2. Customization options Inserting a bullet chart or a clustered chart will open up the following configuration options. {% hint style="info" %} Depending on the type of bullet chart chosen, some of these options may or may not be available. {% endhint %} ### **i) Bullet types** You can change your current bullet chart type from this drop-down.

### **ii) Fill pattern** This option lets you customize the fill pattern/style of the bar. You can set the fill pattern to any of the three relevant IBCS notations: *Solid, Hatched,* or *Outlined.* In the following image, the fill pattern of 'Actual' has been changed to *Outlined* and that of 'Target' has been changed to *Hatched*.

### **iii) Show axis** Enabling this option displays the axis line above the chart.

### **iv) Series display** This option lets you configure the type, height, and color of the bar/line. Depending on the type of chart inserted, the 'Series display' modal will show different properties which are listed below: * **Type** - This drop-down lets you choose the type/format using which you want to display the measures. You can set the type to *Marker, Bar, Line*, *Circle, Overlap, or Integrated.* {% hint style="info" %} The *Overlap* and *Integrated* options are available only for the *Integrated bar with marker*, and *Integrated variance overlap* chart types. {% endhint %} * **Variance bar height** - With this option, you can set the height of the bar that represents the variance/deviation. {% hint style="info" %} The variance bar height option is available only for *Integrated variance overlap, IBCS bullet*, and *Integrated variance bar* chart types. {% endhint %} * **Marker/line/circle size** - This option lets you set the size of the marker/line/circle. The size can be set to *S(Small), M(Medium), L(Large),* or *XL(Extra large).* * **Clustered bar** - Enabling this checkbox will display a clustered bar. You can refer to the [*Clustered Bar*](#iii-clustered-bars) section for additional information. * **Color** - The fill color drop-down lets you choose the color of the bar for every displayed measure.

### **v) Show column** Using this option, you can choose to show data labels for *Target, Variance,* and/or *Variance %.* Using *Show header,* the column header can be enabled or disabled to indicate which labels are shown. In the image below, the data labels for *Variance*, and *Variance %* are shown.

### **vi) Target marker** Enabling this option will display a target marker on the chart.

### **vii) Comparison band** 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 e.g. good, average, and poor. You can add comparison bands by clicking on the 'Comparison bands**'** icon. The following properties are available: * **Compared series** - This drop-down lets you select the measure based on which you want to insert the comparison bands. You can also choose the maximum value of all the series used in the chart. * **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. * **Set label** - If this checkbox is enabled, you can set labels for the ranges. * **Diverging colors** - If you enable this checkbox, you can set different colors for different bands. By default, sequential colors are used. {% hint style="info" %} This option is available only for '*Bullet with marker*' and '*Qualitative bullet with marker*' charts. {% endhint %}

### viii) Appearance This option lets you change the appearance of the bullet charts. Clicking on this option will open up an 'Appearance' model in which you can configure the following properties: **Positive color** - Using this option you can customize the positive color of the bar/marker **Negative color** - Using this option you can customize the negative color of the bar/marker **Axis color** - This option lets you set the axis color of the chart

In this section, we covered bullet and clustered charts. Navigate to the next section to learn more about [waterfall charts](https://docs.inforiver.com/working-with-inforiver/6.-working-with-charts/waterfall-charts).