In this course, Dennis Taylor shows how to analyze and communicate the value of data with charts in Excel. The course starts with the foundations: what the parts of a chart are, what the different types of charts are, and which charts work best for your data. The course then shows how to create a presentation-ready chart in minutes and offers dozens of in-depth tutorials on formatting and fine-tuning charts so they represent data clearly and accurately.
Topics include:
Identifying the plot area, chart area, gridlines, legends, and more
Selecting the right chart type
Creating charts instantly with shortcuts
Choosing a layout
Dealing with empty and hidden cells
Switching rows and columns for a different view of the data
Moving and resizing a chart
Inserting pictures and shapes
Adding labels to a chart
Analyzing existing and future data with trendlines
You must be a lynda.com member to watch this video.
Every course in the lynda.com library contains free videos that let you assess the quality of our tutorials before you subscribe—just click on the blue links to watch them. Become a member to access all 104,069 instructional videos.
If you are already an active lynda.com member, please log in to access the lynda.com library.
Get access to all lynda.com videos
You are currently signed into your admin account, which doesn't let you view lynda.com
videos. For full access to the lynda.com library, log in through iplogin.lynda.com,
or sign in through your organization's portal. You may also request a user account
by calling 1 1 (888) 335-9632 or emailing us at cs@lynda.com.
Get access to all lynda.com videos
You are currently signed into your admin account, which doesn't let you view lynda.com
videos. For full access to the lynda.com library, log in through iplogin.lynda.com,
or sign in through your organization's portal. You may also request a user account
by calling 1 1 (888) 335-9632 or emailing us at cs@lynda.com.
Access to lynda.com videos
Your organization has a limited access membership to the lynda.com library that allows access to only a specific, limited selection of courses.
You don't have access to this video.
You're logged in as an account administrator, but your membership is not active.
Contact a Training Solutions Advisor at 1 (888) 335-9632.
How to access this video.
If this course is one of your five classes, then your class currently isn't in session.
If you want to watch this video and it is not part of your class, upgrade your membership for unlimited access
to the full library of 2,025 courses anytime, anywhere.