Course Outline

Microsoft Excel 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 
  • Create Two Column Charts 
  • Adjusting an Embedded Chart 
  • Move and Resize 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 

Rearranging Chart Data 

  • Changing the way your data is plotted 
  • Plotting Data in Rows instead of Columns 
  • Plotting Data in Columns instead of Rows 
  • Reversing the Plotting Order 
  • Categories 
  • Values 
  • 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 

Replacing Markers with Pictures 

Combination Charts 

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

Chart Type Guide 

  • Area Chart 
  • Bar Chart 
  • Column Chart 
  • Pie and Doughnut Charts 
  • Line Chart 
  • XY Chart 
  • High-Low-Close Line Chart 
  • Radar Chart 
  • 3-D Surface Chart 
Prerequisites:  MS Excel Level 1 or equivalent experience.
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600