Excel Visualization: Visualizing Data Using Line Charts & Area Charts

Microsoft Excel 365    |    Intermediate
  • 13 Videos | 1h 43m 39s
  • Includes Assessment
  • Earns a Badge
Line charts are possibly the most common type of visualization for time-series data, enabling you to see time trends at a glance. These can be augmented with trendlines, used to visualize time trends in data. Stacked area charts are a powerful type of visualization, combining information about trends over time with information about composition and parts of a whole. In this course, you'll learn how to create and customize all of the visualization types above. You'll begin by exploring the purpose of line charts before moving on to formatting and customizing them. You'll then practice using trendlines to evaluate different regression models on data in a line chart. You'll also customize and format these trendlines. Following this, you'll work with area charts and stacked area charts, examining, in detail, the several types of stacked area charts in Excel and customizing their appearance.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    create a basic line chart, experiment with the data label options in a line chart, and change the fill color of the line in a line chart
    illustrate the use of the gradient fill feature, change various aspects of a gradient-filled line chart, and work with radial gradients and linear gradients
    customize various aspects of the line on a line chart, such as the thickness of the line and whether a line is represented using dashes, dots, or both.
    use trendlines to explore the suitability of various kinds of regression models, such as linear regression and polynomial regression via a line chart
    illustrate the use of various features related to trendlines, such as predicting future N periods
    classify the advantages and disadvantages of variants of line charts, such as stacked line charts, 100% stacked line charts, and 3D line charts
  • create a basic area chart, illustrate a major disadvantage of an ordinary area chart, then change the opacity of areas in order to overcome this problem
    create and format an area chart, create a stacked area chart, and illustrate the many advantages of stacked area charts over ordinary area charts
    illustrate how a 100% stacked area chart is computed so that there is no overlap in the areas and the proportions of individual categories from a whole can be assessed easily
    create 3D area charts, illustrate the various ways to overcome certain areas being obscured, and create a 3D stacked area chart
    create a 3D area chart and format the back wall, side wall, and floor
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    1m 57s
    UP NEXT
  • Playable
    2. 
    Visualizing Data Using Excel Line Charts
    9m 21s
  • Locked
    3. 
    Using Gradient Fill on Excel Line Charts
    6m 36s
  • Locked
    4. 
    Customizing and Formatting Excel Line Charts
    7m 27s
  • Locked
    5. 
    Using Linear Regression Trendlines on Line Charts
    8m 19s
  • Locked
    6. 
    Using Advanced Trendline Features on Line Charts
    6m 57s
  • Locked
    7. 
    Distinguishing Different Types of Excel Line Charts
    12m 19s
  • Locked
    8. 
    Creating Basic Area Charts in Excel
    7m 47s
  • Locked
    9. 
    Creating Stacked Area Charts in Excel
    9m 28s
  • Locked
    10. 
    Using 100% Stacked Area Charts in Excel
    8m 14s
  • Locked
    11. 
    Using 3D Area Charts in Excel
    12m 29s
  • Locked
    12. 
    Formatting the Walls in a 3D Area Chart
    5m 27s
  • Locked
    13. 
    Course Summary
    1m 48s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.