Excel: Introduction to Charts and Graphs (2019)

56mBeginner2019-01-17

Authors

Dennis Taylor

Excel expert with 25+ years of experience

Course details

Learn the basics of Excel charts and graphs in this concise course. Excel expert Dennis Taylor begins by explaining Excel chart concepts, including identifying the different elements of a chart and choosing the right chart type. Next, Dennis walks through creating a basic chart, using the Recommended Charts feature and keyboard shortcuts to get the job done quickly. Dennis then covers formatting charts with styles, colors, and more. Finally, he steps through the most popular chart options: column, bar, and line charts. Note that this course is recorded in Excel for Office 365 but anyone using a recent version—including 2019, 2016, and 2013—will be able to follow along.

Learning objectives
Identifying chart elements and chart types
Creating a basic chart
Choosing a chart layout and style
Working with column, bar, and line charts

Skills covered

Data VisualizationOffice 365Microsoft 365SpreadsheetsMicrosoft ExcelData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftDeep Dive (X:Y)

Concepts

0. Introduction

01 - Craft engaging charts and graphs in Excel

1. Understand Excel Chart Concepts

02 - Identify different chart elements
03 - Select the right chart type
04 - Understand chart subtypes
05 - Understand the Chart Tools Ribbon and the Design and Format tabs

2. Create Basic Charts

06 - Select data to display as a chart
07 - Create charts with keystroke shortcuts and the Quick Analysis tool
08 - Develop charts with the Recommended Charts feature
09 - Build charts with standard menu commands

3. Modify Chart Appearances

10 - Choose a chart layout with the QuickLayout option
11 - Select a chart style from a gallery of colorful variations
12 - Switch rows and columns for a different view of the data
13 - Change a chart's type
14 - Move and resize a chart within a worksheet

4. Work with Columns, Bars, and Line Charts

15 - Use column and bar charts
16 - Work with line charts

Conclusion

17 - Next steps