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
|