Working with Different Chart Styles in Excel 2019 for Windows
Excel 2019 (Windows)
| Intermediate
- 6 videos | 23m 30s
- Includes Assessment
- Earns a Badge
- CPE
Excel offers a variety of different chart types and styles for presenting and analyzing data in attractive and interesting ways. Learn how to insert, format, and manipulate Pie, Radar, Scatter, Bubble, Map, and Combo charts. Key concepts covered in this 6-video course include how to insert and edit pie charts, helpful when working with percentages; how to create and edit scatter charts be used to cross-reference values and combine different data types; land how to create and edit a bubble chart used to cross-reference three different types of information in a single chart. Continue by learning how to create and edit radar charts, which can be used to plot five different data values, and how to combine two types of chart by using the combo chart which you can use to create a graphic that combines multiple data types. Finally, you will observe how to create and edit a map chart for situations when you have data relating to locations, so you can use the map chart to plot values on a geographic display. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Working with Different Chart Styles Exercise as well as the associated materials in the Resources section.
WHAT YOU WILL LEARN
-
Create a pie chart
Create a scatter chart
Create a bubble chart -
Create a radar chart
Combine two types of chart
Create a map chart
IN THIS COURSE
-
3m 31sA pie chart can be used to compare the different proportions of an overall total. This is particularly useful when you are working with percentage data in Excel. FREE ACCESS
-
4m 43sIn Excel, a scatter chart can be used to cross-reference values and combine different data types. With this, you can visualize and combine different data series in a single chart, in order to begin analyzing correlations and relationships between different data series. FREE ACCESS
-
3. Creating a bubble chart in Excel 2019 for Windows4m 23sIn Excel, 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. FREE ACCESS
-
4. Creating a radar chart in Excel 2019 for Windows3m 28sA radar chart can be used to visually plot five different data values in Excel. 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 obtain an overall representation of the data series. FREE ACCESS
-
5. Combining two types of chart in Excel 2019 for Windows3m 31sIf you have multiple types of data in your table, then you may find yourself experiencing a problem with your chart's scale and display settings. In Excel, you can use the Combo chart to create a graphic that combines multiple data types. You can even create a secondary axis for your other data series. FREE ACCESS
-
6. Creating a Map chart in Excel 2019 for Windows3m 53sYou can use the Map chart to plot values on a geographic display. This can be useful when you have data relating to regions, countries, or other locations. 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.
