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 EmployeesName / 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