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

LinkedIn Learning

Excel: Charts in Depth

via LinkedIn Learning

Overview

Explore how to add visual appeal to your spreadsheets and workbooks with this in-depth course on the powerful charting features of Microsoft Excel.

Syllabus

Introduction
  • Add power to your data with charts
1. Chart Essentials
  • Create charts with shortcuts and standard techniques
  • Overview of chart types
  • Choose styles and layouts
  • Change chart orientation
  • Move and resize worksheet charts
2. Fine-Tune Your Charts
  • Add a chart element
  • Change the location of source data
  • Deal with empty and hidden cells
  • Change the default chart type and create a template
3. Adjust Chart Elements
  • Modify axes
  • Work with chart and axes titles
  • Link titles to content
  • Add and edit data labels
  • Add a data table
  • Work with gridlines
  • Use legends
  • Add error bars, lines, and up-down bars
  • Analyze existing and future data with trendlines
4. Format Tab Options
  • Use pictures as chart elements
  • Work with shapes and arrows
  • Add shape styles and effects
  • Add floating text and text boxes
  • Work with chart text
  • Apply WordArt styles
5. Work with Popular Chart Types
  • Column and bar charts
  • Line and area charts
  • Pie charts and doughnut charts
6. Other Specialized Excel Charts
  • Combination charts
  • Stock charts
  • Scatter charts
  • Bubble charts
  • Radar charts
  • Gantt charts
7. New Excel Chart Types
  • Overview of new chart types
  • TreeMap charts
  • Sunburst charts
  • Histogram chart
  • Box and whisker chart
  • Pareto chart
  • Waterfall and funnel charts
  • Map charts based on geographic data
8. Change a Chart's Data Source
  • Create charts from multiple data sources
  • Use a table as source data for a chart
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
  • Create in-cell bar charts with conditional formatting
Conclusion
  • Next steps

Taught by

Dennis Taylor

Reviews

4.7 rating at LinkedIn Learning based on 730 ratings

Start your review of Excel: Charts in Depth

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.