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