Using Different Types of Charts in Google Sheets 2020
Google Sheets 2020
| Expert
- 9 videos | 39m 59s
- Includes Assessment
- Earns a Badge
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
-
5m 30sA 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
-
4m 55sA 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. You'll see how easy it is to create and format this type of chart using Google Sheets. FREE ACCESS
-
3. Creating a bubble chart in Google Sheets 20203m 31sIn 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
-
4. Creating a radar chart in Google Sheets 20204m 53sThe 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
-
5. Creating a table chart in Google Sheets 20203m 58sIf 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 discover how to customize a table chart by activating the pagination and sorting options. FREE ACCESS
-
6. Combining two types of charts in Google Sheets 20204m 39sIf 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 axis for your other data series. FREE ACCESS
-
7. Placing data on a map in Google Sheets 20203m 32sGoogle 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
-
8. Using Sparklines in Google Sheets 20204m 18sIn 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
-
9. Publishing your chart in Google Sheets 20204m 43sIf 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 service. You will also see how to download a chart in the format of your choosing 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.
