Data Visualization in Google Sheets
Build an interactive Google Sheets dashboard with column, line, scatter and candlestick charts, list controls, VLOOKUP and conditional formatting rules.
Google Sheets can turn rows of figures into a dashboard that someone else reads at a glance, but only when each chart suits the data behind it. You set up a dashboard around Olympic medal statistics, match chart types to the question being asked, give a viewer a list control for choosing what to display, and apply rules that reformat cells as their values change. Along the way you prepare the source data and format each chart’s titles, axes and gridlines.
What You Will Achieve
- Match a chart type to your data and format its titles, axes and gridlines so the result is easy to read
- Build a dashboard where a viewer picks an item and the linked formulas and charts update
- Refer to cells by name to write cleaner sum and average formulas
- Write rules, including custom formulas, that highlight rows, duplicates or values within a set range
Program Overview
Dashboard Setup and Column Charts
Prepares the worksheet and its data for a basic dashboard, then builds and formats a column chart and introduces named ranges.
- Sheets as a business intelligence platform
- Formatting dates and numbers in the dataset
- Column chart titles, axes, gridlines and series
- Named ranges for sums and averages
Dashboard Controls and Other Charts
Adds data validation lists that drive VLOOKUP calculations, then fills the dashboard with charts suited to different situations.
- Data validation combined with VLOOKUP
- Line plots and histograms
- Candlestick charts and dates converted to text
- Scatter charts and in-cell sparklines
Conditional Formatting Rules
Sets formatting rules that react as dashboard values change, and ends by tidying up the finished dashboard.
- Simple highlight rules and value ranges
- Custom formulas that highlight a row
- Duplicates and wildcard characters for dates
- Editing an existing condition
Certificate Awarded (Paid)
Job Outlook
Spreadsheet charting and dashboard building are used in reporting, sales and survey analysis, and business intelligence work, wherever a team needs its key figures summarized in a single view.
Good for: Spreadsheet users who already handle formulas in Google Sheets and want to present their figures as an interactive dashboard.
Keep in mind: Despite the beginner label, the course builds on earlier Google Sheets study and expects you to be comfortable with the program and its formulas before you start.
Bottom line: A dashboard-centered Google Sheets course that ties chart choice, list controls and rule-based highlighting into one working sheet.
Frequently Asked Questions
Which charts end up on the dashboard?
The dashboard gathers a column chart, a line plot, a histogram, a candlestick chart and a scatter chart, plus sparklines placed inside single cells, including the column sparkline. Most of the charts get their own formatting lesson, covering items such as titles, axes, fonts and gridlines.
Which records feed the dashboard exercises?
Olympic medal tallies drive the early dashboard lessons. The exercises also draw on shark attack records and Marine Technology data from the ASX, the Australian Securities Exchange.
How does a viewer change what the dashboard shows?
Data validation creates a list the viewer chooses an item in. VLOOKUP then pulls the matching values into the calculations, so charts such as the line plot and the histogram redraw for the chosen item.
What can the conditional formatting rules highlight?
The rules highlight cells that meet a simple condition, values that fall between two limits, a whole row through a custom formula, duplicate entries, and dates matched with wildcard characters. A later lesson shows how to change the condition of an existing rule.


There are no reviews yet.