You can create a variance sparkline using the VariSparkline function in a formula: =VARISPARKLINE(variance, reference?, mini?, maxi?, mark?, tickunit?, legend?, colorPositive?, colorNegative?, vertical?). The function has the following parameters: variance: Number or reference that represents the length of the bar, such as 2 or "A1". reference: (optional) Number or reference that represents the location of the reference line, such as 0 or "A2"; default value is 0. mini: (optional) Number or reference that represents the minimum values of the sparkline, such as -5 or "A3"; default value is -1. maxi: (optional) Number or reference that represents the maximum values of the sparkline, such as 5 or "A4"; default value is 1. mark: (optional) Number or reference that represents the position of the mark line, such as 3 or "A5"; default value is 0. tickunit: (optional) Number or reference that represents the tick unit, such as 1 or "A6"; default value is 0. legend: (optional) Boolean that represents whether to display the text. The default value is false. colorPositive: (optional) String that represents the color scheme for when the variance is larger than the reference; default value is "green". colorNegative: (optional) String that represents the color scheme for when the variance is smaller than the reference; default value is "red". vertical: (optional) Boolean that represents whether the box's direction is vertical or horizontal; default value is false.