Skip to main content

Bullet Sparklines

Bullet sparklines are compact bar charts to show progress toward a goal. They typically include a measure bar, a target line, and shaded areas that represent the actual value, benchmark value, and ranges, respectively.

When to use bullet sparklines​

  • Tracking performance against a target: Compare a value to a predefined goal—ideal for KPIs, sales objectives, or benchmarks.
  • Showing progress: Use color‑coded zones (such as red, yellow, or green) to highlight underperformance, acceptable ranges, or strong results.
  • Providing quick insights: Present key metrics clearly in dashboards or reports where space is limited.

Create a bullet sparkline​

  1. On the Insert tab, select Sparklines.
  2. Under Other Sparkline, choose Insert Bullet sparkline. The BulletSparkline Setting dialog opens.
  3. Set the parameters.
  4. Click Ok. The sparkline is inserted into the selected cell.

Edit a bullet sparkline​

  1. Select the bullet sparkline in your workbook.
  2. On the Sparkline tab, select Settings. The BulletSparkline Setting dialog opens.
  3. Adjust the parameters, then click Ok.
  4. Copy and paste the sparkline cell to duplicate the configuration in another location, as needed.

Bullet sparkline parameters​

The bullet sparkline formula supports the following format:

=BULLETSPARKLINE (measure, target, maxi, good, bad, forecast, tickUnit, colorScheme, vertical, measureColor, targetColor, maxiColor, goodColor, badColor, forecastColor, allowMeasureOverMaxi, barSize)
```excel

| Parameter   | Description |
|-------------|-------------|
| Measure     | Define the length of the measure bar. Accepts a number or cell reference.|
| Target      | Set the location of the target line. Accepts a number or cell reference.|
| Maxi        | Set the maximum value of the sparkline. Accepts a number or cell reference.|
| Forecast    | Define the length of the forecast line. Accepts a number or cell reference. Default: `0`.|
| Good        | (*Optional*) Set the length of the good bar. Accepts a number or cell reference. Default: `0`.|
| Bad         | (*Optional*) Set the length of the bad bar. Accepts a number or cell reference. Default: `0`.|
| Tickunit    | (*Optional*) Set the interval between tick marks. Accepts a number or cell reference. Default: `0`.|
| ColorScheme | (*Optional*) Specify the base color used to generate a set of sparkline colors. Default: `#A0A0A0`.|
| Vertical    | (*Optional*) Display the sparkline vertically.|
| Additional Formula Parameters | (*Optional*) Customize the sparkline appearance using the following options:<br/><br/> <ul><li>**`measureColor`** – Ses the color of the measure bar.</li><li>**`targetColor`** – Set the color of the target line.</li><li>**`maxiColor`** – Set the color of the maximum area.</li><li>**`goodColor`** – Set the color of the good area.</li><li>**`badColor`** – Set the color of the bad area.</li><li>**`forecastColor`** – Set the color of the forecast line.</li><li>**`allowMeasureOverMaxi`** – Allow the measure bar to exceed the maximum.</li><li>**`barSize`** – Set the bar thickness according to the cell height/width (value between `0` and `1`).</li></ul>|