Course Outline
Charting In Excel
Two Hour "Byte Size" Course
All Versions

Phone:717-560-3552
E-Mail: Registrar@pceasy.com

Program Objectives: Students will learn various Charting Features utilizing Microsoft Excel. 

• Pivot Tables

• Charting in Excel

• Setting Up Data for Charting

• Chart Types

  • Area/Bar

  • Column/Line
  • Pie/XY Scatter
  • Doughnut/3-D Surface
  • Radar
  • Combination/Bubble
  • Stock/Cylinder
  • Cone/Pyramid
  • Special Chart Types

• Using the Chart Wizard Icon

• Legend Tab

• Charting Toolbar

• Moving/Resizing the Chart

• Enhancing the Chart

• Changing the Chart Type

• Changing the Chart Colors

• Using Fill Effects

• Walls to Transparent

• Changing the Chart Title

• Moving/Resizing the Title or Legend

• Changing Text Alignment/Font Size

• Format, Insert, and Chart Menus

• Previewing/Printing the Chart

• Removing a Chart

• Additional Charting Features

• Charting Non-contiguous Data

• Data Label on a Pie Chart

• Placing a Picture Behind Chart Data

• Formatting a Chart

• Editing a Data Series

• Data Series Options

• Editing a Data Point on a Column Chart

• Editing an Axis Scale

• Changing Color/Patterns/Font & Font Size

• Adding Cell Contents to a Chart

• Adding Drawing Objects to a Chart

• Inserting a Picture into a Chart

• Moving a Chart to Another Sheet

• Creating a Combination Chart

• Primary Versus Secondary Axis

• Adding a New Data Series to a Chart

• Adding a Trendline

• Adding New Data Within a Present Data Series

• Append New Data to an Existing Data Series (Manually)

• Append New Data to an Existing Data Series (Macro)

• Printing Multiple Charts on a Page

• Creating a Histogram

• Creating a Pareto Chart

• Creating a Cumulative Percentage Chart