New Training: Visualising Data

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.