Excel Visualization: Visualizing Data Using Line Charts & Area Charts

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 youll learn how to create and customize all of the visualization types above. Youll begin by exploring the purpose of line charts before moving on to formatting and customizing them. Youll then practice using trendlines to evaluate different regression models on data in a line chart. Youll also customize and format these trendlines. Following this youll work with area charts and stacked area charts examining in detail the several types of stacked area charts in Excel and customizing their appearance.