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:
Then type in the BULLETSPARKLINE formula in the area you would like to display the outcome:
By adding the values you would like to calculate the BULLETSPARKLINE formula for, Excellentable will generate the outcome:
A

B



1


2


3


4
