Excel 2003 Charts and Graphs

 

 

Course Length

Three hours

 

Prerequisites

Excel 2003 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 modify chart elements, add arrows, text, borders and shading, plus much more.

 

Course Topics

  • Learn about the different Excel chart types and chart elements

  • Create a chart using the ChartWizard    

  • Select, move, resize, and delete an embedded chart

  • Display an embedded chart in a new window

  • Create a default chart

  • Choose a different chart type

  • Change the default chart type

  • Change the source data

  • Use Range Finder in embedded charts

  • Add or change a chart or axis title

  • Display or hide axes and display gridlines

  • Show or hide the legend

  • Label data points

  • Display or hide the data table

  • Select, resize, move, and format a chart object  

  • Change the order and options for data series

  • Add error bars and a trendline to a data series

  • Plot data on a second y-axis     

  • Change the chart type for a data series

  • Create graphic data markers for a data series

  • Add labels and arrows to a chart

  • Create a custom chart type and apply a user-defined chart type

  • Print an embedded chart and a chart sheet

  • Change the size of a printed chart          

  • Link a chart title to cell contents

  • Change legend text

  • Modify source data by changing the chart

  • Plot empty cells

  • Smooth the angles of line charts

  • Rotate the position of slices in a pie chart

 

What Participants Receive

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

 

 

 

 

[Home   |     Services   |   Courses   |   Instructors  |  References  |  Contact Us]