New Skills

New Training: Visualising Data

by Team Nuggets
New Training: Visualising Data picture: A
Published on May 6, 2021

In this 9-video skill, CBT Nuggets trainer Simona Millham shows the options we have in Google Sheets such as charts and conditional formatting for displaying our data visually. Watch this new training.

Watch the full course: Google Sheets

This training includes:

  • 9 videos

  • 1 hour of training

You’ll learn these topics in this skill:

  • Introduction

  • Conditional Formatting

  • Charts Quick Start!

  • Explore the Common Chart Types

  • Scatter and Bubble Charts

  • Waterfall and Candlestick Charts

  • Radar, Histogram, Tree Map, and Geo Charts

  • Other Visualisations

  • Sparklines

How to Add a Chart to Google Sheets

One of the most useful tools spreadsheet applications have is the ability to create various types of charts to help visualize data. It's one thing to have a bunch of data listed in rows and columns, but humans are very visual creatures. Being able to digest that data in a visual way is a big help. All major spreadsheet applications can create charts including Google Sheets.

Adding a chart in Google Sheets is easy. First, click on the Insert button in the toolbar at the top of Google Sheets. Then select Chart from the drop-down menu. This will insert a generic chart inside of your Google Sheet.

Once that chart is inserted, an options panel will appear on the left side of the browser. From this panel, you can define what kind of chart you want to use, which columns and rows will be used for that chart as well as other options.



Ultimate Tech Support Cert Guide

A 119-page guide to every CompTIA, Microsoft, Cisco, VMware, and Citrix certification, and how they fit into your career.

By submitting this form you agree that you have read, understood, and are able to consent to our privacy policy.

Don't Miss Out

Get great content delivered to your inbox.

I have read and understood the privacy policy, and am able to consent to it.

Recommended Articles

Get CBT Nuggets IT training news and resources

I have read and understood the privacy policy and am able to consent to it.

© 2022 CBT Nuggets. All rights reserved.Terms | Privacy Policy | Accessibility | Sitemap | 2850 Crescent Avenue, Eugene, OR 97408 | 541-284-5522