Excel 2007

Effective Charting

½ Day

Learn How to

Understand how to produce charts in Excel

Understand the use of the different chart types

Format charts effectively

Create chart templates

Combine charts

Pre-Requisites

Delegates should be familiar with working in Excel as can be gained from our Excel 2007 Core Skills course.

Charts

Chart Types

Choosing an Appropriate Chart Type

Selecting Data for Charting

Using the Chart Wizard

Creating a Chart

 

Pie Charts

What is a Pie Chart

Pie Chart Limitations

Exploding a Pie Chart

 

Column/Bar Charts

Charting Multiple Data Series

Changing the Scale of a Chart Axis

 

Line Charts

What is a Line Chart

Formatting a Line Chart

Formatting Charts

Formatting and Editing Chart Objects

Formatting Chart Axis

Changing the Chart Colours

Annotating Charts

 

Other Chart Types

Bubble Charts

Doughnut Charts

Gantt Charts

Radar Charts

Scatter Charts

Stock Charts

Surface Charts

Area Charts

Timelines

Thermometer Charts

 

Re-using Charts

Changing a Charts Type

Combination Charts

Change a Charts Source Data

Saving a Chart as a Template