Showcase your data with charts using Excel
Class length: 1/2 day
Prerequisite: The following course (or equivalent knowledge): Excel Level I
Objectives
Upon successful completion of this Lab, students will be able to:
· Create a chart from worksheet data using the F11 function key and the Chart Wizard, and identify chart components.
· Create a pie chart to showcase a single data range.
· Create column and line charts to track data over time.
· Create embedded and linked Excel chart objects applications other than Excel.
Lab content
Lab Activity 1: Picture your Excel data in a chart
· Create charts quickly with the F11 key and the Chart Wizard
· Identify chart components
Lab Activity 2: Emphasize a single data range with a pie chart
· Create a pie chart
· Work with pie chart options
· Change a chart’s location
Lab Activity 3: Track data over time
· Create column charts
· Create line charts
· Save chart settings
Lab Activity 4: Spice up your reports with charts
· Include an embedded chart object
· Include a linked chart object
· Discover the differences between embedding and linking
