Bullet Sparklines

To create bullet sparklines in the workbook:

  1. Click Insert from the menu.

  2. Click Sparkline and select the bullet sparkline under Other Sparkline from the list.

  3. In the BulletSparkline Setting dialog box:

    1. Set the parameters as described below.

    2. Click OK.

  4. The sparkline is displayed in the cell. To edit the sparkline, click Design from the menu and select Settings. The BulletSparkline Setting dialog box will be displayed again.

  5. Copy and paste the cell as needed to finalize your bullet sparklines.
Bullet sparkline parameter Description
Measure Number or reference that represents the length of the measure bar, such as 5 or "A1".
Target Number or reference that represents the location of the target line, such as 7 or "A2".
Maxi Number or reference that represents the maximum value of the sparkline, such as 10 or "A3".
Forecast Number or reference that represents the length of the forecast line, such as 8 or "A6"; the default value is 0.
Good (Optional) Number or reference that represents the length of the good bar, such as 3 or "A4"; the default value is 0.
Bad (Optional) Number or reference that represents the length of the bad bar, such as 1 or "A5"; the default value is 0.
Tickunit (Optional) Number or reference that represents the tick unit, such as 1 or "A7"; the default value is 0.
ColorScheme (Optional) String that represents the color scheme for generating a group of colors to display the sparkline; the default value is "#A0A0A0".
Vertical (Optional) Boolean that represents whether to display the sparkline vertically; the default value is false.

The bullet sparkline formula has the following syntax:

=BULLETSPARKLINE (measure, target, maxi, good, bad, forecast, tickUnit, colorScheme, vertical, measureColor, targetColor, maxiColor, goodColor, badColor, forecastColor, allowMeasureOverMaxi, barSize)
Additional formula parameters
measureColor (Optional) String that represents the color of measure bar.
targetColor (Optional) String that represents the color of target line.
maxiColor (Optional) String that represents the maxi area color.
goodColor (Optional) String that represents the good area color.
badColor (Optional) String that represents the bad area color.
forecastColor (Optional) String that represents the forecast line color.
allowMeasureOverMaxi (Optional) Boolean that represents if the measure could exceed maxi area; the default value is false.
barSize (Optional) Number that represents that the percentage of bar width/height according to the cell height/ width (value > 0 and value <= 1).