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

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

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

• Pivot Tables in Excel

• Charting In Excel

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

• Setting Up Data For Charting

• Charting Terminology

• Using the Chart Wizard To Create A Chart

• Moving The Chart On The Page

• Resizing The Chart

• Enhancing The Appearance Of The Chart

• Changing The Chart Type

• Changing The Chart Colors

• Using Fill Effects To Embellish The Chart

• Changing The Chart Title

• Moving The Title Or Legend

• Resizing The Title Or Legend

• Printing The Excel Chart (With The Data)

• Printing The Excel Chart (Without Data)

• Removing A Chart

• Restoring A Chart

• Editing A Data Series

• Editing An Axis

• Moving A Chart to Another Sheet

• Adding Drawing Objects To A Chart

• Adding A Data Table To A Chart

• Formatting A Data Table In A Chart

• Inserting A Picture Into A Chart

• Creating A Combination Chart

• Adding A New Data Series To A Chart

• 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