Excel 2007 Charts and Graphs

Course Length

Three hours

Prerequisites

Excel 2007 Introduction or equivalent experience

Course Description

Learn how to manage your numerical data by creating charts and graphs that effectively present information. Then, emphasize your point by customizing your chart—learn how to format and modify chart elements, change chart type, layout, and style, plus much more.

Course Topics

  • Explore chart types
  • Create a chart
  • Change chart type
  • Change the chart type for a data series
  • Change the default chart type
  • Identify chart elements
  • Activate, move, resize, and delete an embedded chart
  • Change chart location
  • Print an embedded chart on a page by itself
  • Select, resize, move, and delete a chart element
  • Manually change the layout of chart elements
  • Format chart elements
  • Apply a predefined chart layout
  • Apply a predefined chart style
  • Switch the data series between rows and columns
  • Update an existing chart with changed values
  • Add or remove data on an embedded chart by dragging sizing handles
  • Add new data to a chart by pasting
  • Remove a data series
  • Explode the slice(s) in a Pie chart
  • Rotate the slices in a Pie chart
  • Draw attention to the small slices in a Pie chart
  • Change the distribution and display of data points in a Pie chart
  • Display a graphic image in a chart element
  • Change the series overlap and gap width for a data series
  • Plot data on a second y-axis
  • Add floating text to a chart
  • Smooth the angles in a Line chart
  • Add lines or up/down bars
  • Add error bars
  • Add a trendline to a data series
  • Save a chart as a template
  • Apply a chart template to an existing chart
  • Delete a chart template
  • Use the “Select Data Source” dialog box
  • Review chart specifications and limits

What Participants Receive

Each participant receives a guide containing step-by-step instructions and practice exercises.