Using Different Types of Charts in Google Sheets 2020

Google Sheets 2020    |    Expert
  • 9 videos | 39m 59s
  • Includes Assessment
  • Earns a Badge
Likes 4 Likes 4
Google Sheets offers a huge variety of different chart types and styles for presenting and analyzing your data in attractive and interesting ways. Learn how to insert, format, and manipulate Pie, Radar, Scatter, Bubble, Map, and Combo charts. You will also see how to share your charts by downloading a copy or publishing via a link or embedded code.

WHAT YOU WILL LEARN

  • create, edit and customize a pie chart
    create, edit and customize a scatter chart
    create, edit and customize a bubble chart
    create, edit and customize a radar chart
    create and customize a table chart
  • create and customize a combo chart
    insert and customize a map chart
    use Sparkline function to track trends
    share and publish a chart

IN THIS COURSE

  • Playable
    1.  Creating a pie chart in Google Sheets 2020
    5m 30s
    A pie chart is used to compare the different proportions of an overall total. This is particularly useful when you are working with percentage data in Google Sheets. A well-formatted pie chart can enhance the appearance… FREE ACCESS
  • Playable
    2.  Creating a scatter chart in Google Sheets 2020
    4m 55s
    A scatter chart is used to cross-reference values and combine different data types. One data type can be represented by the x-axis, and a different data type can be represented by the y-axis. You can then use the legend… FREE ACCESS
  • Locked
    3.  Creating a bubble chart in Google Sheets 2020
    3m 31s
    In Google Sheets, a bubble chart can be used to cross-reference three different types of information in a single chart. Different data values can be visualized according to where the point is placed on the x- and y-axes… FREE ACCESS
  • Locked
    4.  Creating a radar chart in Google Sheets 2020
    4m 53s
    The radar chart can be used to visually plot five different data values in Google Sheets. Each axis represents a particular value or measurement. Once the chart has been inserted, you can compare the form and size of the… FREE ACCESS
  • Locked
    5.  Creating a table chart in Google Sheets 2020
    3m 58s
    If you have to present a large amount of data as a table, then you can choose to insert a table chart to display this information. Learn how to insert a table chart and select the data you want to show. You will also… FREE ACCESS
  • Locked
    6.  Combining two types of charts in Google Sheets 2020
    4m 39s
    If you have two different types of data tables, then you may find have a problem with your chart's scale. In Google Sheets, you can create a chart that combines multiple chart types. You can even create a secondary… FREE ACCESS
  • Locked
    7.  Placing data on a map in Google Sheets 2020
    3m 32s
    Google Sheets allows you to display your data as an infographic. Here you will see how to place your data onto a map in order to display it clearly and attractively. FREE ACCESS
  • Locked
    8.  Using Sparklines in Google Sheets 2020
    4m 18s
    In Google Sheets, you can insert miniature charts that track the overall trend of a data series. These are called Sparklines and they can help the reader to grasp the general progression of your data series. FREE ACCESS
  • Locked
    9.  Publishing your chart in Google Sheets 2020
    4m 43s
    If you want to share your chart with other people, you can publish it online, download or move it to its own sheet. This tutorial will show you how to obtain the embed code and insert it into a blog post using the Blogger… FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.