Bullet charts and clustered bar charts
Last updated
Last updated
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.
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.
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.
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
A clustered bar chart is applicable only if any of the Actual, Target, or Additional target types are set to 'Bar'.
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.
Inserting a bullet chart or a clustered chart will open up the following configuration options.
Depending on the type of bullet chart chosen, some of these options may or may not be available.
You can change your current bullet chart type from this drop-down.
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.
Enabling this option displays the axis line above the chart.
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.
The Overlap and Integrated options are available only for the Integrated bar with marker, and Integrated variance overlap chart types.
Variance bar height - With this option, you can set the height of the bar that represents the variance/deviation.
The variance bar height option is available only for Integrated variance overlap, IBCS bullet, and Integrated variance bar chart types.
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 section for additional information.
Color - The fill color drop-down lets you choose the color of the bar for every displayed measure.
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.
Enabling this option will display a target marker on the chart.
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.
This option is available only for 'Bullet with marker' and 'Qualitative bullet with marker' charts.
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.
