Variance Sparklines

To create variance sparklines in the workbook:

1. Click Insert from the menu.

2. Click Sparkline and select the variance sparkline under Other Sparkline from the list.

   

3. In the VariSparkline Setting dialog box:

   1. Set the parameters as described below.

   2. Click OK.

   

4. The sparkline is displayed in the cell. To edit the sparkline, click Design from the menu and select Settings. The VariSparkline Setting dialog box will be displayed again.

5. Copy and paste the cell as needed to finalize your vari sparklines.

   

Variance sparkline parameter	Description
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"; the default value is 0.
Mini	(Optional) Number or reference that represents the minimum values of the sparkline, such as -5 or "A3"; the default value is -1.
Maxi	(Optional) Number or reference that represents the maximum values of the sparkline, such as 5 or "A4"; the default value is 1.
Mark	(Optional) Number or reference that represents the position of the mark line, such as 3 or "A5"; the default value is 0.
TickUnit	(Optional) Number or reference that represents the tick unit, such as 1 or "A6"; the default value is 0.
ColorPositive	String that represents the color scheme for when the variance is larger than the reference; the default value is "green".
ColorNegative	String that represents the color scheme for when the variance is smaller than the reference; the default value is "red".
Legend	(Optional) Boolean that represents whether to display the text. The default value is false.
Vertical	(Optional) Boolean that represents whether the box's direction is vertical or horizontal; the default value is false.
The variance sparkline formula has the following syntax: =VARISPARKLINE(variance, reference, mini, maxi, mark, tickunit, legend, colorPositive, colorNegative, vertical)