Creating Charts & Graphics

Learners can explore the use of charts in Excel for Office 365 to enhance the look of data in this 10-video course, which demonstrates how to use several of Excel’s charts, and how to customize charts for specific data. You will learn to use the Quick Analysis tool to insert a chart, and how to use visualized patterns to display data. This course then examines how to label charts, and how to choose which elements to show, including labels, legends, and titles. Learners will observe how to use the Formatting tools to change a chart’s appearance. You will learn to customize your chart axes, how to adjust measurements, how to move maximum and minimum values, and how to change the point where the two axes cross in the chart. This course examines how to use Sparklines to represent an overall trend of a selected data range, and to format them further. Finally, you will learn how to select a color scheme, mark different data points, and even highlight the negative values in a trend.