Excel Visualization: Visualizing Data Using Line Charts & Area Charts
Microsoft Excel 365
| Intermediate
- 13 videos | 1h 38m 9s
- 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
-
1m 57s
-
9m 21s
-
3. Using Gradient Fill on Excel Line Charts6m 36s
-
4. Customizing and Formatting Excel Line Charts7m 27s
-
5. Using Linear Regression Trendlines on Line Charts8m 19s
-
6. Using Advanced Trendline Features on Line Charts6m 57s
-
7. Distinguishing Different Types of Excel Line Charts12m 19s
-
8. Creating Basic Area Charts in Excel7m 47s
-
9. Creating Stacked Area Charts in Excel9m 28s
-
10. Using 100% Stacked Area Charts in Excel8m 14s
-
11. Using 3D Area Charts in Excel12m 29s
-
12. Formatting the Walls in a 3D Area Chart5m 27s
-
13. Course Summary1m 48s
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.
