|
EXCEL CHARTS IN WORD
|
|
You
will need to download the project to view
the full curriculum file
|
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:
- Highlight all cells with text
in rows A through C, except the title row,
row 1 and the sum row, row 13.
- Go to: Insert>Chart and
create a pie chart within this spreadsheet
for this information. Title the chart: Student
Ages.
- 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:
- Highlight columns A,B, and
E. (HINT: hold down the Control Key) Again,
not including the title or total lines.
- Go to: Insert>Charts and
choose the "Column" bar graph style.
Or choose another style if this does not come
out well.
- 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
- Highlight all of the information
in the spreadsheet, originally created in
"Cell
Formatting"
- Go to: Edit> Copy
- Open a new MS Word document
and save it as :Lesson 4.student name
- 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.
- Repeat this process for one
of the charts created above.
- 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.
- Go to: File> Print Preview
to assess the final product.
|
