Learn how to create a new chart in Excel. Jen McBee demonstrates how to create a chart using the Insert Ribbon as well a great shortcut, and how to add a data series to an existing chart, switch between rows and columns in source data, and how to use Quic
- [Instructor] Showing users how to create charts…is one of my very favorite things to do…when I'm teaching Excel,…and it's because once users learn how easy it is…to create a great looking chart,…their anxiety level goes way down,…and it becomes fun instead of daunting.…On the Excel 2016 MOS exam,…you're probably going to be asked to create a new chart,…and you'll be asked to modify that chart by…adding a data series.…You may also be asked to switch the row and column data…so that what's currently showing…on the horizontal axis is flipped,…and it's just a different way to display your data.…
It's good to take a look at both ways…to make sure that your data is visually being displayed…in a way that will best suit the information…that you're trying to give to your users.…I'm going to show you three ways…to create a new chart.…One of them will include using the quick analysis tool.…It's a great tool available to us in Excel 2016,…and it's going to make creating a chart easier…than you ever imagined.…I have the 06_01 exercise file open,…
Author
Jennifer McBee
Released
12/25/2016The course begins with an overview of the certification program and how to prepare for the exam. Next, Jennifer walks you through all the certification objectives. Throughout the course, she provides you with opportunities for hands-on practice with exercises and chapter challenges, and wraps up with a full-length practice test that emulates exam 77-727.
- Recall the steps taken to change the margins of a worksheet.
- Explain how to repeat row and column headings when printing a document.
- Recognize three available options when merging cells.
- Identify the most effective way to filter and sort data in a table.
- Recognize the order of operations used when calculating data.
- Explain why a user might want to switch the row and column data in a chart.
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome1m
-
-
1. Microsoft Office Specialist Exam Overview
-
Prepare for the exam2m 33s
-
2. Create and Manage Workbooks and Worksheets
-
3. Manage Data Cells and Ranges
-
Format cells and ranges7m 51s
-
4. Create Tables
-
Create and manage tables4m 22s
-
Filter and sort a table6m 41s
-
-
5. Perform Operations with Formulas and Functions
-
6. Create Charts and Objects
-
Create charts4m 47s
-
Format charts5m 50s
-
Insert and format objects5m 22s
-
-
7. Final Practice Exam
-
Conclusion
-
Next steps19s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Create charts