sparkline barchart no options

Bar Chart Options for Sparklines in Google Sheets – Example Pictures

Sparklines, as seen in this overview post on sparklines, are quick, simple charts that can be inserted directly a the cell of a spreadsheet created with Google Sheets.  One of their strengths is their simplicity.  However, there are several options that can be used to expand a sparkline’s functionality.  Below, we focus on the options available for use with the bar chart type of sparkline.  

sparkline barchart no options
sparkline barchart with no options

Bar chart sparkline options

max determines the maximum value on the horizontal (x) axis

sparkline barchart max 12
"max",12 Note that this is the value in the first cell so the entire chart is representing just that one value.

sparkline barchart max 21
"max",21 Note that this is the sum of the values in the first two cells so the entire chart is representing just these two values.

sparkline barchart max 61
"max",61 This is the value of all of the cells added together the chart is the same as if you had not specified a max value.

sparkline barchart max 61 with a negative
"max",61 This is the value of all of the cells added together the chart is the same as if you had not specified a max value. Note that barcharts must use absolute values as the chart is rendered the same way whether or not the cells are negative.

 

sparkline barchart max 75
"ma",75 setting of 75. This chart illustrates that you can specify a chart max larger than the chart itself and the chart will scale down.

 

color1 determines the first color color used for bars in the chart

sparkline barchart with a color1 set to red
"color1","red" setting of red. Note that is changes the 1st, 3rd, 5th color, etc

color2 determines the second color color used for bars in the chart

sparkline barchart with color1 set to red and color2 set to yellow
"color1","red" and "color2","yelow" Note that this changes not only the first and second colors, but all of the colors.

empty how to treat empty cells

sparkline barchart with no empty option specified
No empty parameter is set for this sparkline bar chart

sparkline barchart with empty parameter set to zero
zero give the cell a value of zero for the sparkline

sparkline barchart with the empty parameter set to ignore
ignore ignore the cell, rendering the chart as if it does not exist

nan how to treat cells with non-numeric data

  • convert let Sheets try to convert the character(s) in the cell to a number. Good luck on this one.
  • ignore ignore the cell, rendering the chart as if that value does not exist
  • Note in the image that the “ignore” option behaves the same as not designating this option at all.

rtl changes the direction of the chart from left-to-right to right-to-left

  • true The direction of the chart is flipped
  • false The direction of the chart stays the same
  • Note that the “false” option behaves the same as not designating this option at all. 

Video explanation

Follow image below for the live Google doc with sparklines

docs share icon

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>