6th Grade Math Textbook, Fundamentals

 &KDSWHU

Technology:

Create Graphs

Objective To use spreadsheet software to display data in bar graphs, line graphs, or

circle graphs

The table at the right shows prices of merchandise sold
at a baseball stadium. How can you use software to display
and analyze the data?

One way to do this is to use a spreadsheet.

You can use spreadsheet software to make a bar graph

to represent the data.

Use the following steps.

8-13

Item Price

Batting helmet $12

Banner $8

Bat $10

Team jacket $40

Team photo $5

Merchandise Sold at Baseball Stadium

Merchandise

Price (dollars)

50

40

30

20

10

(^0) Batting
Helmet
Banner Bat Team
Jacket
Team
Photo
Merchandise Sold at Baseball Stadium
Price (dollars)
Merchandise
Team Photo
Team Jacket
Bat
Banner
Batting Helmet
010 2030405060
Step 1 Enter the data from the table into column A
and column B of a spreadsheet, as shown at
the right.
Step 2 Highlight the data, including the column heads.
Step 3 From the Insertmenu, select Chart, or use the
Chart Wizardicon on the toolbar. This will take
you through a series of steps that enables you
to create the graph. Here, select Columnto
display the data in a vertical bar graph, and
input the graph title and axis labels. Click
Finishwhen done.
To represent the data as a horizontal bar graph,
select Bar. Click Finishwhen done.