The max matters

Now you have an easy visual of how many injuries crashes cause in each precinct, which can help you use your resources more effectively. But you might also want to know how frequently car crashes result in injury in different precincts. This might tell you whether lowering the speed limit in an area would save lives.

Now you'll add sparklines for the proportion of accidents that cause injuries. You'll set the limites of the scale at 0 and 1 to make absolute instead of relative comparisons. This will illustrate the impact of context when interpreting sparklines.

The frequency of car crashes causing injury is given in cells J2:J10 as a starting point for your sparklines.