Column and bar charts

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. You want to compare how many students chose each favourite fruit. Which chart type is best?

A A chart with no bars or labels

B A column or bar chart

2. Which step comes first when making a column chart in a spreadsheet?

A Select the labels and the values

B Type the chart title in a blank cell

3. Which data should you select to chart pet types and how many students own each one?

A The pet names and the numbers next to them

B Only the pet names and nothing else

4. After selecting your data, what do you do to make the chart appear?

A Choose Sort, then Filter

B Choose Insert, then Chart

5. Which describes a column chart?

A The bars stand upright (vertical)

B The bars lie sideways (horizontal)

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left column		Right column
1Insert > Chart > Column chart		AMakes a chart with upright (vertical) bars to compare amounts in different categories
2Insert > Chart > Bar chart		BThe labels were not selected, so the bars have no category names under or beside them.
3Select the labels and the values together before inserting the chart		CA column chart compares amounts in categories. It is not the best choice for showing change over time.
4Use a column chart to compare how many pets each class has		DMakes a chart with sideways (horizontal) bars to compare amounts in different categories
5Select only B2:B5 (just the numbers), then Insert > Chart		EClass labels in A2:A5, pet counts in B2:B5, Insert > Column chart
6Insert > Column chart to show how a number changes over time		FSelect A1:B5, then Insert > Chart

Definitions

bar chart

Fill in the Blanks

Complete each line of code by filling in the missing parts.

Names in A2:A5 are the ______ Numbers in B2:B5 are the values

Select A1:B5 first Then click Insert > _____

Labels in A1:A4, values in B1:B4 Select _____, then Insert > Chart

Column chart: ________ bars Bar chart: horizontal bars

Bar charts _______ amounts in categories

Spot the Error

Shade in the letter of the line that contains an error.

Question 1

A Select A1:B5

B Select B1:B5

C Choose Column chart

D Add a chart title

Question 2

A Select A1:B5

B Click Insert chart

C Choose Column: sideways bars

D Check the bars lie sideways

Question 3

A Column charts: sideways bars

B Bar charts: sideways bars

C Both compare categories

Question 4

A Select the labels and values

B Go to the Format menu

C Choose Column chart

D Type a chart title

Question 5

A A1: Pet, B1: Votes

B A2: Dog, B2: 8

C A3: Cat, B3: 6

D Select A1:A3

E Insert a column chart

Answer Key

Column and bar charts

Section A: Quick Questions

B — A column or bar chart

A — Select the labels and the values

A — The pet names and the numbers next to them

B — Choose Insert, then Chart

A — The bars stand upright (vertical)

Section B: Match the Pairs

Insert > Chart > Column chart → Makes a chart with upright (vertical) bars to compare amounts in different categories

Insert > Chart > Bar chart → Makes a chart with sideways (horizontal) bars to compare amounts in different categories

Select the labels and the values together before inserting the chart → Select A1:B5, then Insert > Chart

Use a column chart to compare how many pets each class has → Class labels in A2:A5, pet counts in B2:B5, Insert > Column chart

Select only B2:B5 (just the numbers), then Insert > Chart → The labels were not selected, so the bars have no category names under or beside them.

Insert > Column chart to show how a number changes over time → A column chart compares amounts in categories. It is not the best choice for showing change over time.

Section C: Definitions

bar chart — A chart that uses bars to compare amounts in different categories. Select the labels and values, then choose Insert chart. Column charts have upright bars; bar charts lie sideways.

Section D: Fill in the Blanks

Names in A2:A5 are the labels
Numbers in B2:B5 are the values

Select A1:B5 first
Then click Insert > Chart

Labels in A1:A4, values in B1:B4
Select A1:B4, then Insert > Chart

Column chart: vertical bars
Bar chart: horizontal bars

Bar charts compare amounts in categories

Section E: Spot the Error

B — Only the values are selected, so the bars have no labels. Select both the labels and the values, like A1:B5.

C — Column charts have upright bars. A bar chart has sideways bars, so the line should say Choose Bar.

A — Column charts have upright (vertical) bars. Only bar charts lie sideways.

B — Charts are made from the Insert menu. The Format menu only changes how things look.

D — Only the labels in column A are selected, so there are no values to draw as bars. Select A1:B3.