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
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
Introduction
- Craft engaging charts and graphs in Excel
Understand Excel Chart Concepts
- Identify different chart elements
- Select the right chart type
- Understand chart subtypes
- Understand the Chart Tools Ribbon and the Design and Format tabs
Create Basic Charts
- Select data to display as a chart
- Create charts with keystroke shortcuts and the Quick Analysis tool
- Develop charts with the Recommended Charts feature
- Build charts with standard menu commands
Modify Chart Appearances
- Choose a chart layout with the QuickLayout option
- Select a chart style from a gallery of colorful variations
- Switch rows and columns for a different view of the data
- Change a chart's type
- Move and resize a chart within a worksheet
Work with Columns, Bars, and Line Charts
- Use column and bar charts
- Work with line charts
Conclusion
- Next steps