Microsoft IT Academy—Excel 2010

Lesson 6: Working with Charts and Graphics

Learning Goals: The goal of this lesson is for students to successfully create charts to present data in Microsoft Excel 2010. The student will learn to apply,create, and modify various types of charts.

Learning Objectives: On completion of this lesson, students will be able to do the following:

Create charts

Move, resize, and delete charts

Modify chart titles

Move and format chart elements

Change chart types and organize source data

Update data and format the axes

Add gridlines and arrows

Use Illustrations

Preview and print charts

Creating Charts

Microsoft Excel enables users to create ______of ______using ______. Charts make data ______. Data can be ______to show comparisons, patterns, and trends.

Before creating a chart, you must decide if the ______is ______for a chart and then decide which ______of chart will best display the data.

There are several types of charts to choose from, but the chart you choose depends on the message you are trying to ______.

The ______types of charts include the ______, bar, and ____.

Here is a quick tutorial in Microsoft showing you how to Create a Basic Chartin Excel 2010:

ABC Manufacturing 2010 Employees
Name / Employee ID / Age / Weekly Salary / New Salary
Bill Cole / 218 / 32 / $352.87 / $361.69
Gloria Doer / 316 / 34 / $445.88 / $458.14
Lauren Huang / 375 / 51 / $375.02 / $386.27
Mitchell Harms / 381 / 19 / $419.42 / $434.10
Pattie Hovey / 429 / 47 / $520.35 / $535.96
Eric Erwin / 452 / 21 / $409.32 / $423.65
Wanda Shas / 483 / 24 / $414.25 / $414.25
David Mott / 553 / 62 / $390.22 / $403.88
Totals / $3,327.33 / $3,417.94
Average / $415.92 / $427.24

When creating a chart, you have to select the data you want to ______in the chart

  • For ______data, use the ______key to make your selections
  • Next, select the ______tab, ______button in the ______group
  • Choose the chart that will ______display your data.
  • Normally,______select the ______or Averages

You can either create the chart on a ______sheet or ______it in the spreadsheet page

Moving and Resizing Charts

Once a chart is created you can ______or ______it

You must ______the chart to bring up the ______Ribbon which allows for chart editing

There are ______tabs: Design, Layout, and Format

Once selected, charts can be resized, moved, and deleted

If you decide to ______a change , use ______on the Quick Access Toolbar

Modifying Chart Titles and Adding Axis Labels

Adding chart______and ______makes the data more ______for the user

These options can be found on the ______Tab, Labels Group of the Chart Tools Ribbon

Legends can be moved on the chart by using the ______option on the ______Tab or ______it to the desired location.

Add ______Labels by selecting the Data Labels ______on the ______tab of the Chart Tools Ribbon or ______the chart area and choose Data Labels from the ______menu.

Moving and Formatting Chart Elements

Updating Data and Formatting the Axes

______in the chart will ______update to ______the updates in the worksheet.

The axis ______can be ______to better suit the data used in the chart.

To scale the axis,______in an ______ and choose the ______dialog box from the shortcut menu.

Another way to ______the axis is by choosing the ______from the Chart Tool ______.

Adding Gridlines and Arrows

______and ______help to identify the data in the chart.

Previewing and Printing Charts

Lesson 6 Notes—Page 1 of 7