Aspire     Data Visualization Mastery     Data Visualization Track 1: Data Visualization with Excel

---

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.

---

---

Objectives

Excel Visualization: Visualizing Data Using Line Charts & Area Charts 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