Using charts in Sheets 2022

Google Sheets 2022    |    Intermediate
  • 10 videos | 40m 32s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 15 users Rating 4.5 of 15 users (15)
Google Sheets offers a huge variety of different chart types and styles for presenting and analyzing your data in attractive and interesting ways. Discover how to insert, format, and manipulate Pie, Scatter, Bubble, Radar, Map, and Combo charts. You will also learn how to use the Sparkline function to track trends in a data series. Lastly, you can share your charts by downloading a copy or publishing via a link or embedded code.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in using charts in sheets 2022 course
    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

  • 47s
    This video outlines the key content covered in the Using charts in Sheets 2022 course including creating a pie chart, combining two types of charts, and publishing your chart. FREE ACCESS
  • 4m 35s
    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 of your data. FREE ACCESS
  • Locked
    3.  Creating a scatter chart in Sheets 2022
    5m 15s
    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 to explain what each point on the chart means. FREE ACCESS
  • Locked
    4.  Creating a bubble chart in Sheets 2022
    3m 50s
    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 and the size of the point itself. Formatting a bubble chart can ensure that the data represented is understood. FREE ACCESS
  • Locked
    5.  Creating a radar chart in Sheets 2022
    4m 38s
    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 shape created along the five different axes to have an overall representation of the data series. FREE ACCESS
  • Locked
    6.  Creating a table chart in Sheets 2022
    4m 8s
    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. You are able to select the data you want to show in a table chart, as well as customize a table chart by activating the pagination and sorting options. FREE ACCESS
  • Locked
    7.  Combining two types of charts in Sheets 2022
    4m 22s
    If you have two different types of data tables, then you may 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 axis for your other data series. FREE ACCESS
  • Locked
    8.  Placing data on a map in Sheets 2022
    3m 53s
    Google Sheets allows you to display your data as an infographic. You are able to place your data onto a map in order to display it clearly and attractively by editing and customizing your geo chart. FREE ACCESS
  • Locked
    9.  Using Sparklines in Sheets 2022
    4m 28s
    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
    10.  Publishing your chart in Sheets 2022
    4m 35s
    If you want to share your chart with other people, you can publish it online, download or move it to its own sheet. You can obtain the embed code and insert it into a blog post using the Blogger service. You are also able to download a chart in the format of your choice with Google Sheets. 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.

YOU MIGHT ALSO LIKE

Course Entering data in Excel 365 (2023)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Course Getting started with charts in Excel 365
Rating 4.5 of 1670 users Rating 4.5 of 1670 users (1670)
Course Excel Visualization: Visualizing Data Using Line Charts & Area Charts
Rating 4.6 of 150 users Rating 4.6 of 150 users (150)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Customizing charts in Excel 365
Rating 4.5 of 250 users Rating 4.5 of 250 users (250)
Course Managing & calculating data in Sheets 2022
Rating 4.5 of 16 users Rating 4.5 of 16 users (16)
Course Creating & managing sheets in Google Sheets 2022
Rating 4.6 of 86 users Rating 4.6 of 86 users (86)