Sparklines

Error and Uncertainty in Google Sheets

Evan Kramer

Instructor

Sparklines

  • SPARKLINE() function
    • data: The cell(s) to plot
    • options: Options to configure the plot

Sparklines of number of vehicles crashed by precinct

Error and Uncertainty in Google Sheets

Options

  • charttype
    • bar, line, column, etc.
  • max
    • upper limit

Sparklines of number of vehicles crashed by precinct

Error and Uncertainty in Google Sheets

Examples

-=SPARKLINE(data, [options])

Sparklines with formulas visible and 'max' and 'charttype' options specified

Error and Uncertainty in Google Sheets

Examples

-=SPARKLINE(H2, [options])

Sparklines of number of vehicles crashed by precinct

Error and Uncertainty in Google Sheets

Examples

  • =SPARKLINE(H2, {"charttype", "bar"})
    • Curly braces
    • [Option name], [option]

Sparkline with formula visible and displaying 'charttype' option

Error and Uncertainty in Google Sheets

Let's practice!

Error and Uncertainty in Google Sheets

Preparing Video For Download...