# Excel Visualization: Visualizing Data Using Line Charts & Area Charts

Microsoft    |    Intermediate
• 13 videos | 1h 38m 9s
• Includes Assessment
Rating 4.6 of 150 users (150)
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
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

• 3.  Using Gradient Fill on Excel Line Charts
• 4.  Customizing and Formatting Excel Line Charts
• 5.  Using Linear Regression Trendlines on Line Charts
• 6.  Using Advanced Trendline Features on Line Charts
• 7.  Distinguishing Different Types of Excel Line Charts
• 8.  Creating Basic Area Charts in Excel
• 9.  Creating Stacked Area Charts in Excel
• 10.  Using 100% Stacked Area Charts in Excel
• 11.  Using 3D Area Charts in Excel
• 12.  Formatting the Walls in a 3D Area Chart
• 13.  Course Summary

## 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 27 users (27)
Rating 5.0 of 2 users (2)
Rating 4.5 of 435 users (435)

## PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.7 of 576 users (576)
Rating 4.5 of 917 users (917)
Rating 4.5 of 435 users (435)