This video course covers the basics of creating, editing, and formatting a chart.  It discusses basic chart types such as a combination chart and a pie chart. It also shows you how to create a default chart as well as a custom chart type.

 

 

Learning Objectives
  • Explore how to differentiate between different chart types and recognize chart elements.
  • Identify the different steps involved in creating charts.
  • Discover how to edit existing charts by resizing, changing chart type, moving chart elements and adding/ deleting data series by using contextual tabs menus and short cut keys.
  • Recognize how to apply formatting techniques to a chart.
  • Recognize how to change the default chart type and create custom chart types.
Last updated/reviewed: March 12, 2024
5 Reviews (30 ratings)

Reviews

4
Anonymous Author
I have not used charts in quite some time. The course is very good with highlighting the basics so you can quickly jump in and start.

3
Anonymous Author
Good course explaining the basics on charts within excel. Definitely learned some new tips and tricks to apply on a go foward.

3
Anonymous Author
This was a good refresher on using charts, especially newer features in Excel

4
Anonymous Author
Good overview of chart making. I had no experience and this was very helpful.

5
Anonymous Author
Very good overview of charts. Great refresher and good use of examples

Prerequisites
Course Complexity: Foundational

This course is presented for Excel 2019 and Microsoft Office 365 users. However, users with Excel 2016 should have little difficulty.

Education Provider Information
Company: Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact: For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Instructor for this course
Course Syllabus
INTRODUCTION AND OVERVIEW
  Introduction to Chart Basics4:31
  Creating a Chart9:32
  Edit Chart Data7:23
  Formatting Column Charts10:20
  Formatting Pie Charts8:47
  Graphics and Scaling6:19
  Chart Types and Conclusion9:35
CONTINUOUS PLAY
  Chart Basics56:27
SUPPORTING MATERIAL
  Slides: Chart BasicsPDF
  Chart Basics Glossary/ IndexPDF
  Workbook: Charts BasicXLSX
REVIEW AND TEST
  REVIEW QUESTIONSquiz
 FINAL EXAMexam