Course Outline

Excel 2002/2003/2004 Charting
Design many types of creative and professional-looking Charts and Graphs! Create Chart Sheets and Embedded Charts, format & modify Chart items with colors, gradients, textures, fill effects. Enhance with Graphic Objects. 6 hours
Introduction 
  • Why Create a Chart? 
  • Anatomy of a Chart 
  • Choosing the Best Chart Type 
  • Selecting Data 

Creating a New Chart 

  • Creating an Embedded vs a Separate Chart 
  • Adjusting an Embedded Chart 

Modifying the Chart Type 

  • Changing to Another Chart Type 
  • Changing the 3-D View 

Changing Chart Element 

  • Activating and Selecting Chart Items 
  • Changing Fonts and Value Axis Settings 
  • Changing Colors and Patterns 
  • Working with Pie chart
  • Creating an open-high-low-close line chart

Rearranging Chart Data 

  • Plotting Data series in Rows instead of Columns 
  • Plotting Data series in Columns instead of Rows 
  • Reversing the Plotting Order of categories, values or series
  • Changing the Plotting Order of Data Series 
Adding Text and Titles 
  • Adding Title to a Chart and Axes 
  • Adding Data Labels 
  • Adding "unattached" text to a Chart 

Adding and Removing Data Series 

Combination Charts 

  • Combination with a single y-axis 
  • Combination with a secondary y-axis 

Setting the Default Chart Type

  • Changing the default chart type
  • Using the selected chart as the default chart type
  • Saving a custom chart type to apply to other charts

Creating a "Progress Chart"

Choosing the Right Chart Type

  • Area Chart 
  • Column Chart 
  • Bar Chart 
  • Line Chart 
  • Pie and Doughnut Charts 
  • Stock chart
  • XY Chart 
  • Bubble chart
  • Radar Chart
  • 3-D Surface Chart 
  • Cone, cylinder and pyramid charts
  • High-Low-Close Line Chart ??  
Prerequisites:  MS Excel Level 1 or equivalent experience.
Revised 7/28/2008
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600