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

LinkedIn Learning

Excel 2010: Charts

via LinkedIn Learning

Overview

Analyze and communicate the data in spreadsheets more efficiently with charts in Excel.

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.

Syllabus

Introduction
  • Welcome
  • Using the exercise files
1. Understanding Excel Chart Concepts
  • Identifying chart elements like plot area, chart area, gridlines, and legends
  • Selecting the right chart type
  • Understanding chart terminology
  • Understanding the Ribbon and the Design, Layout, and Format tabs
2. Creating Basic Charts Quickly
  • Selecting data to display as a chart
  • Creating charts instantly with shortcuts
  • Creating charts with standard menu commands
  • Creating presentation-ready charts with just a few adjustments
  • Creating graphic-in-cell charts with sparklines
3. Fine-Tuning Charts with Design Tab Choices
  • Switching rows and columns for a different view of the data
  • Setting a default chart type and creating a template
  • Dealing with empty and hidden cells
  • Choosing a chart layout
  • Choosing a chart style from 48 colorful variations
  • Changing the location of a chart
  • Moving and resizing a chart
4. Layout Tab Options: Inserting Pictures, Shapes, and Text Boxes
  • Using pictures as chart elements
  • Adding shapes and arrows
  • Adding floating text and text boxes
5. Layout Tab Options: Adding Titles, Labels, and Legends
  • Adding, editing, and removing chart titles
  • Adding horizontal and vertical titles
  • Linking titles to content
  • Showing numbers of different scales
  • Specifying the position of tick marks and axis labels
  • Changing the numeric format on labels
  • Adding, editing, and removing legends
  • Adding and editing data labels
  • Showing the source of a chart's data
6. Layout Tab Options: Using Axes and Gridlines
  • Modifying axis scaling
  • Working with gridlines
7. Layout Tab Options: Using the Analysis Tools
  • Analyzing existing and future data with trendlines
  • Adding drop lines
  • Adding high-low lines and up-down bars
  • Adding error bars
8. Format Tab Options: Adding Shapes and WordArt Styles
  • Selecting shape fill and outline
  • Adding shape effects
  • Applying WordArt styles
9. Using Other Formatting Tools
  • Formatting lines and borders
  • Filling an area with a color gradient
  • Specifying line style, color, and weight
  • Working with chart text
  • Changing the rotation of chart text
10. Adjusting Specific Chart Types
  • Using column and bar charts
  • Using line charts
  • Using pie charts
  • Using area, stock, and XY charts
  • Using doughnut, bubble, and radar charts
11. Changing a Chart's Data Source
  • Pasting new data into a chart
  • Creating charts from multiple data sources
  • Adding new data using a table
12. Printing and Sharing Charts
  • Printing charts
  • Copying and linking charts with Word and PowerPoint
Conclusion
  • Next steps

Taught by

Dennis Taylor

Related Courses

Reviews

Start your review of Excel 2010: Charts

Never Stop Learning!

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

Sign up for free