EXCEL CHARTS IN WORD Summary: In this lesson students will learn how to create charts in excel, and paste them into a Word document. This lesson should be taught after teaching “Cell Formatting”. Taught together, students will learn all beginner-level excel skills necessary for basic competency with Microsoft Excel. For examples of this lesson, see “charts in word example”. Overview: Skill Level: Intermediate/Beginner Excel, to be taught only AFTER students have completed “Cell Formatting” Activity Goals: • Learn how to create charts in excel and paste them into a Word document • Encourage creativity among students Materials Needed: • Computers • MS Word • MS Excel Prerequisites: • Knowledge of MS Word • Successful completion of lesson: “Cell Formatting” Procedure Open the excel spreadsheet created in “Cell Formatting”. Creating charts: 1. Highlight all cells with text in rows A through C, except the title row, row 1 and the sum row, row 13. 2. Go to: Insert>Chart and create a pie chart within this spreadsheet for this information. Title the chart: Student Ages. 3. Move the chart with your mouse to fit below the written information on your spreadsheet. Right click on the chart and choose Chart Options. Choose the Data Labels tab and choose Show Value. Notice changes. Creating bar graphs: 1. Highlight columns A,B, and E. (HINT: hold down the Control Key) Again, not including the title or total lines. 2. Go to: Insert>Charts and choose the “Column” bar graph style. Or choose another style if this does not come out well. Page 1, Lesson 4: Excel Charts in Word
3. To change the font or style of certain words within the chart or graph, simply double click on the words. This will then change the font size, style, color etc. for all words of that category, for example, all names. Excel Charts in Word 1. Highlight all of the information in the spreadsheet, originally created in “Cell Formatting” 2. Go to: Edit> Copy 3. Open a new MS Word document and save it as :Lesson 4.student name 4. Go to: Edit>Paste Special and paste this information as a link, so that any changes made to the original excel document will change the Word doc as well. 5. Repeat this process for one of the charts created above. 6. Move the information around on the MS Word page to make it look presentable. Write a title and any other information that may help explain the information provided. 7. Go to: File> Print Preview to assess the final product.
Page 2, Lesson 4: Excel Charts in Word
First Name Ariel Catherine Corey Jules Eric Kyle Makeda James Marc Shawna Jamal
Last Name Gibson Marks Williams Johnson Jones Harper Woods Fairfield Kohen Lewis Nowles
Age 27 38 25 30 26 45 27 18 33 52 21 342
Job Title Supervisor Trainer Trainer Field Manager Trainer Director Specialist Specialist Trainer Deputy Director Trainer
Salary $40,000.00 $27,000.00 $27,000.00 $33,000.00 $27,000.00 $60,000.00 $35,000.00 $35,000.00 $27,000.00 $50,000.00 $27,000.00 $388,000.00
Student Ages
27 38 25 30 26
52
21
33
18
27
45
Ariel Gibson Catherine Marks Corey Williams Jules Johnson Eric Jones Kyle Harper Makeda Woods James Fairfield Marc Kohen
$70,000.00
$60,000.00
$60,000.00
$50,000.00
$50,000.00
$40,000.00 $35,000.00 $35,000.00 Series1 $27,000.00 $27,000.00 $27,000.00
$40,000.00 $33,000.00 $27,000.00
$30,000.00
$27,000.00
$20,000.00
$10,000.00
$0.00
Gibson Corey Jules Eric Kyle Makeda James
Marks
Williams
Johnson
Jones
Harper
Woods
Fairfield
Kohen Marc
Lewis Shawna
Nowles Jamal
Ariel
Catherine