The hbar and vbar sparklines can be used to show variations or ranges in data.
You can create an hbar or vbar sparkline using the HBarSparkline or VBarSparkline function in a formula: =HBARSPARKLINE(value, colorScheme?) or =VBARSPARKLINE(value, colorScheme?).
The functions have the following parameters:
value: Number or reference that represents the length of the bar, such as 0.3 or "A1". If value is greater than 100% or smaller than -100%, an arrow is displayed.
colorScheme: (optional) String that represents the color of the bar; default value is "gray".
HBarSparkline: Positive values, sparkline starts at left of cell; negative values, sparkline starts at right of cell.
VBarSparkline: Positive values, sparkline starts at bottom of cell; negative values, sparkline starts at top of cell.