Setting up a basic dashboard

Data Visualization in Google Sheets

Raina Hawley

Owner/Instructor of OzGrid Business Applications

Dashboard features

Getting your data right for the dashboard

Extracting your data

• Keep the message in mind
• Pull only the data you need
• Formula of reference

Formulas of reference

• Calculation that picks up a value from another cell
• = Sheet2!A1
  • "Point to Sheet 2 cell A1 and return what is in cell A1"

 

The column chart

Let's practice!

Data Visualization in Google Sheets