Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel: Introduction to Charts and Graphs

via LinkedIn Learning

Overview

Learn the basics of charts and graphs in Excel. Find how to create engaging data visualizations with these simple Excel chart tips.

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.

Syllabus

Introduction
  • Craft engaging charts and graphs in Excel
1. 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
2. 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
3. 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
4. Work with Columns, Bars, and Line Charts
  • Use column and bar charts
  • Work with line charts
Conclusion
  • Next steps

Taught by

Dennis Taylor

Related Courses

Reviews

Start your review of Excel: Introduction to Charts and Graphs

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free