BULLETSPARKLINE

The bullet sparkline formula has the following options:

Option	Description
Measure	A number or reference that represents the length of the measure bar, such as 5 or "A1".
Target	A number or reference that represents the location of the target line, such as 7 or "A2".
Maxi	A number or reference that represents the maximum value of the sparkline, such as 10 or "A3".
Good	A number or reference that represents the length of the good bar, such as 3 or "A4". This setting is optional. The default value is 0.
Bad	A number or reference that represents the length of the bad bar, such as 1 or "A5". This setting is optional. The default value is 0.
Forecast	A number or reference that represents the length of the forecast line, such as 8 or "A6". This setting is optional. The default value is 0.
Tickunit	A number or reference that represents the tick unit, such as 1 or "A7". This setting is optional. The default value is 0.
ColorScheme	A string that represents a color scheme for displaying the sparkline. This setting is optional. The default value is "#A0A0A0".
Vertical	A boolean that represents whether to display the sparkline vertically. This setting is optional. The default value is false.

Sample Usage

In order to use the BULLETSPARKLINE formula, start with your edited Excellentable:

Capture 2017-07-04 at 10.34.20.png

Then type in the BULLETSPARKLINE formula in the area you would like to display the outcome:

Capture 2017-07-04 at 10.35.54.png

By adding the values you would like to calculate the BULLETSPARKLINE formula for, Excellentable will generate the outcome:

Capture 2017-07-04 at 10.37.13.png

There were errors rendering macro:

An unknown error occurred.