Highlights

Overview

In the Bullet Chart image below:

• The black line represents the Target value.
• The green bar represents the Performance value.
• The grey area represents the Range value.

The data for a Bullet Chart must be formatted as a single comma-separated element and the values must be in the following order:

Target, Performance, Range

If it is not in this format (for example, if it is an array of values), use the JOIN function to convert it to a comma-separated value.

Download the data source to build the example Bullet Chart in this article.

1. Select a Table component, then select the Data panel.
2. Click Insert Function and from theText category, select the JOIN function.
3. In the formula bar, select the data element, click Insert Function button and select the ARRAY function (the ARRAY function returns a list of values).
4. In the formula bar, select the first data element in the ARRAY function.



5. Select the Target value (cell D2 using our example spreadsheet).
6. In the formula bar, select the second data element in the ARRAY function.



7. Select the Performance value (cell B2 using our example spreadsheet).
8. In the formula bar, select the third data element in the ARRAY function.



9. Select the Range value (cell C2 using our example spreadsheet).
10. Select the Properties tab and from the Format as drop-down list select Mini Chart: Bullet.

Applying indicators

You can apply indicators to the Performance value on the Bullet Chart, for example to change the color of the bar depending on its value.

Applying comparative ranges

You can apply a different color to compare a range of values. For example, in the following Bullet Chart: 450 displays as grey, 200 displays as orange, and 100 displays as blue.

The following data source demonstrates how you can do this. The first value for the range of values must be the largest in the series.

Build the following formula for this Klip. The comparative range that displays in a different colour are the cell values: C2, C3 and C4.

JOIN( ARRAY( A2, B2, C2, C3, C4 ) , glue )

For this to display, change the format to Mini Chart: Bullet and select  the following colors in the Properties panel.

Learn more:

Now that you know more about the Bullet Charts, check out these tutorials:

• JOIN and MAP functions
• ARRAY function

Important concepts

These articles provide an overview of important concepts for building Klips:

• How to use Mini Chart formats
• How to build Sparkline components
• How to use Horizontal Mini Charts in a Klip