Creating a column chart for your dashboard

In this chapter, you will start to put together your own dashboard.

Your first step is to create a basic column chart showing fatalities, injured, and uninjured statistics for the states of Australia over the last 100 years.

This exercise is part of the course

Data Visualization in Google Sheets

View Course

Exercise instructions

In A1 of Sheet1, use a formula that refers to the heading in your Shark Attacks dataset. This can take the form of ='Sheet Name'!A1.
In your Shark Attacks dataset, select the State column and the Fatal, Injured, and Uninjured statistics, and then create a chart.
Copy and paste this chart to Sheet 1 and change the chart to a column chart.

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise