<p>You can create a bullet sparkline using the BulletSparkline function in a formula: <strong>=BULLETSPARKLINE(measure, target, maxi, good?, bad?, forecast?, tickunit?, colorScheme?, vertical?, measureColor?, targetColor?, maxiColor?, goodColor?, badColor?, forecastColor?, allowMeasureOverMaxi?, barSize?)</strong>.</p> <p>The function has the following parameters:</p> <p><strong>measure</strong>: Number or reference that represents the length of the measure bar, such as 5 or "A1".</p> <p><strong>target</strong>: Number or reference that represents the location of the target line, such as 7 or "A2".</p> <p><strong>maxi</strong>: Number or reference that represents the maximum value of the sparkline, such as 10 or "A3".</p> <p><strong>good</strong>: (optional) Number or reference that represents the length of the good bar, such as 3 or "A4"; default value is 0.</p> <p><strong>bad</strong>: (optional) Number or reference that represents the length of the bad bar, such as 1 or "A5"; default value is 0.</p> <p><strong>forecast</strong>: (optional) Number or reference that represents the length of the forecast line, such as 8 or "A6"; default value is 0.</p> <p><strong>tickunit</strong>: (optional) Number or reference that represents the tick unit, such as 1 or "A7"; default value is 0.</p> <p><strong>colorScheme</strong>: (optional) String that represents the color scheme for generating a group of colors to display the sparkline; default value is "#A0A0A0".</p> <p><strong>vertical</strong>: (optional) Boolean that represents whether to display the sparkline vertically; default value is false.</p> <p><strong>measureColor</strong>: (optional) String that represents the color of measure bar.</p> <p><strong>targetColor</strong>: (optional) String that represents the color of target line.</p> <p><strong>maxiColor</strong>: (optional) String that represents the maxi area color.</p> <p><strong>goodColor</strong>: (optional) String that represents the good area color.</p> <p><strong>badColor</strong>: (optional) String that represents the bad area color.</p> <p><strong>forecastColor</strong>: (optional) String that represents the forecast line color.</p> <p><strong>allowMeasureOverMaxi</strong>: (optional) Boolean that represents if the measure could exceed maxi area; default value is false.</p> <p><strong>barSize</strong>: (optional) Number that represents that the percentage of bar width/height according to the cell height/ width. (value &gt; 0 &amp;&amp; value &lt;= 1)</p>