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

Provider Logo

Excel for Mac 2016: Charts in Depth

via LinkedIn Learning

Overview

Learn to create different kinds of Excel charts, from column, bar, and line charts to doughnut and scatter charts, with Excel for Mac 2016.

Charts allow you to communicate information visually, with greater impact than tables or raw data. They also happen to be one of the most powerful and easy-to-use features in Microsoft Excel for Mac. Let Dennis Taylor show you how to create different kinds of Excel charts, from column, bar, and line charts to doughnuts and scatter charts, and decide which type works best for your data. Learn how to fine-tune your chart's colors and style; add titles, labels, and legends; insert shapes and pictures; and pull data from multiple sources. Along the way, Dennis offers shortcuts and tips for being more productive and efficient.

Syllabus

Introduction
  • Welcome
  • Using the exercise files
1. Create Basic Charts Quickly
  • Select data to display as a chart
  • Create charts with a keystroke or with ribbon icons
  • Use the Recommended Charts options
2. Excel Chart Concepts
  • Identify chart elements
  • Select the right chart type
  • Use chart terminology
  • Use Charts Ribbon tab
3. Adjust Chart Appearances with Chart Design Tab Choices
  • Add titles, labels, gridlines and other chart elements
  • Choose a chart layout from the Quick Layout button
  • Select chart colors and chart styles
  • Use the Switch Row/Column button for a different view of the data
  • Change a chart's data source
  • Adjust chart settings to manage empty and hidden cells
  • Change a chart's type and save it as a template
  • Change the location of a chart
4. Control Chart Element Options
  • Modify axes
  • Add, edit, and remove chart titles and axis titles
  • Link titles to content
  • Add and edit data labels
  • Add a data table
  • Add error bars
  • Work with gridlines
  • Add, edit, and remove legends
  • Add drop lines, up/down bars, and high-low lines
  • Analyze existing and projected data with trendlines
5. Use Format Tab Options and Other Visual Features
  • Add color backgrounds to chart elements
  • Explore chart element formatting: Fill, outline, and effects
  • Alter chart text styles: Fill, line, and effects
  • Add shapes, text boxes, and arrows; add text and apply styles
  • Use pictures as chart elements
  • Use right-click and double-click to quickly adjust formats
6. Use Specific Chart Types
  • Column and bar charts
  • Line charts and area charts
  • Pie charts and doughnut charts
  • Scatter charts and bubble charts
  • Stock charts and radar charts
7. Change a Chart's Data Source
  • Add or delete data in a chart
  • Create charts from multiple data sources
  • Update charts automatically with a table as source data
8. Specialized Excel Charts
  • Create combination charts
  • Create Gantt charts
  • Create frequency charts
  • Use Developer tab controls to create dynamic charts
  • Produce dynamic charts by using filters
9. Print and Share Charts
  • Print charts
  • Copy and link charts with Word and PowerPoint
10. In-Cell Chart Alternatives
  • Create graphic-in-cell charts with sparklines
  • Use symbols and the REPT function for in-cell charts
  • Use Conditional Formatting options to create in-cell charts
11. Chart Manipulation Tools
  • Move and resize a chart within a worksheet
  • Convert a chart to a graphic
Conclusion
  • Goodbye

Taught by

Dennis Taylor

Related Courses

Reviews

0.0 rating, based on 0 reviews

Start your review of Excel for Mac 2016: Charts in Depth

Never stop learning Never Stop Learning!

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

Sign up for free