Changing the plotted range
It's just as easy to change a range as it is to delete it. For this task, have a go at changing the range of your chart so it now only showcases the top 3 states' fatal statistics.
This exercise is part of the course
Data Visualization in Google Sheets
Exercise instructions
- Remove the
Injuredseries from your chart so you are only plotting theFatalseries. - Change the data range so that you are only plotting the first three states with the highest number of fatalities.
- To do this, you will need to use the chart editor to adjust the existing data ranges
'Shark Attacks'!A1:A9and'Shark Attacks'!C1:C9so that the chart only displays fatalities fromNSW,QLD, andWA.
- To do this, you will need to use the chart editor to adjust the existing data ranges
- Finally, change the chart title to 'Top 3 States Number of Fatalities'.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise