Get startedGet started for free

Can't start a fire without a spark(line)

So you've made some predictions, you've checked their accuracy, and you see that crashes with multiple vehicles tend to cause the most injuries. This isn't all that suprising. Since you're charged with public safety, your task is to see how to use your resources to make the roads safer without spending all day creating dashboards.

This is a great opportunity to use sparklines to compare data quickly. Just as a reminder, the SPARKLINE() function takes the data (in this case the cell) as the first argument, and sparkline options are enclosed in a set of curly braces ({}), with a comma (,) to separate keys and settings, and with a semi-colon (;) to separate individual options. Thus, your options argument should take the form of the following:

{"option1", option1setting; "option2", option2setting}

This exercise is part of the course

Error and Uncertainty in Google Sheets

View Course

Exercise instructions

  • In cell I2, add a sparkline that reflects the number of vehicles that crashed in the precinct. - Make sure the chart displays as a "bar" chart. - Set the the limit ("max") as the highest number of vehicles crashed in any precinct.
  • Add sparklines in cells I3:I10 that depict the number of vehicles crashed in that precinct as a proportion of the total from the highest precinct.

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise