Working with Different Chart Styles in Excel 2019 for Windows

Excel 2019 (Windows)    |    Intermediate
  • 6 videos | 23m 30s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.5 of 446 users Rating 4.5 of 446 users (446)
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 31s
    A 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 43s
    In 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
  • Locked
    3.  Creating a bubble chart in Excel 2019 for Windows
    4m 23s
    In 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
  • Locked
    4.  Creating a radar chart in Excel 2019 for Windows
    3m 28s
    A 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
  • Locked
    5.  Combining two types of chart in Excel 2019 for Windows
    3m 31s
    If 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
  • Locked
    6.  Creating a Map chart in Excel 2019 for Windows
    3m 53s
    You 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.

YOU MIGHT ALSO LIKE

Rating 4.5 of 15 users Rating 4.5 of 15 users (15)
Rating 4.6 of 153 users Rating 4.6 of 153 users (153)
Rating 4.6 of 150 users Rating 4.6 of 150 users (150)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 487 users Rating 4.5 of 487 users (487)
Rating 4.5 of 234 users Rating 4.5 of 234 users (234)
Rating 4.6 of 716 users Rating 4.6 of 716 users (716)