Changing a chart's type

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. You made a column chart but want a line chart of the same data. What is the best way to do it?

A Right-click the chart and choose Change Chart Type

B Delete the data and type it in again

2. After you use Change Chart Type, what happens to your data in the spreadsheet?

A It is deleted and must be typed in again

B It stays the same and the chart uses it

3. Where do you start to change a chart's type in a spreadsheet?

A Right-click the chart

B Right-click an empty cell far from the chart

4. Why might you change a column chart to a line chart for the same data?

A To compare how the two types show the data, such as a trend over time

B To change the numbers in the table

5. You have monthly temperatures for a year. Which new chart type suits the data when you use Change Chart Type?

A Pie chart, because it shows change over time

B Line chart, because it shows change over time

Match the Pairs

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

Left column		Right column
1Right-click chart > Change Chart Type		AOpens the menu where you pick a different chart type for the chart you already made
2Change Chart Type > Line		BChange Chart Type > Line (for Jan to Dec temperatures)
3To compare how two chart types show the same data, switch the chart type and keep the data		CThis wastes time because Change Chart Type switches the chart to a line chart using the same data.
4Some data suits one chart type better, such as monthly temperatures on a line chart		DTurns a column chart into a line chart using the same data, with no retyping
5Delete the chart and type all the data again to make it a line chart		EA pie chart does not suit data over time or with many values; a line or column chart would be a better choice.
6Change Chart Type > Pie (for 12 months of temperatures)		FRight-click > Change Chart Type > Column, then Line

Definitions

Change Chart Type

Fill in the Blanks

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

Right-click the chart Then choose _________________

___________ the chart > Change Chart Type

Over time: Change Chart Type > ____

Right-click chart > Change Chart Type Choose ___ only for parts of a whole

Chart 1: Column of A1:B6 Change Chart Type > Line Chart 2: Line of _____

Spot the Error

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

Question 1

A Select the column chart

B Right-click the chart

C Choose Change Chart Type

D Retype the data for Line

Question 2

A Click the column chart

B Right-click inside the chart

C Choose Change Chart Title

Question 3

A Click the pie chart

B Right-click cell A1

C Choose Change Chart Type

Question 4

A Data: temperature each day

B Goal: show change over time

C Change Chart Type to Pie

Question 5

A Data: pocket money by friend

B Goal: compare friends

C Right-click, Change Chart Type

D Pick Line to compare friends

Answer Key

Changing a chart's type

Section A: Quick Questions

A — Right-click the chart and choose Change Chart Type

B — It stays the same and the chart uses it

A — Right-click the chart

A — To compare how the two types show the data, such as a trend over time

B — Line chart, because it shows change over time

Section B: Match the Pairs

Right-click chart > Change Chart Type → Opens the menu where you pick a different chart type for the chart you already made

Change Chart Type > Line → Turns a column chart into a line chart using the same data, with no retyping

To compare how two chart types show the same data, switch the chart type and keep the data → Right-click > Change Chart Type > Column, then Line

Some data suits one chart type better, such as monthly temperatures on a line chart → Change Chart Type > Line (for Jan to Dec temperatures)

Delete the chart and type all the data again to make it a line chart → This wastes time because Change Chart Type switches the chart to a line chart using the same data.

Change Chart Type > Pie (for 12 months of temperatures) → A pie chart does not suit data over time or with many values; a line or column chart would be a better choice.

Section C: Definitions

Change Chart Type — A chart option (right-click the chart) that switches it to another type, like column to line, using the same data so you do not have to enter it again.

Section D: Fill in the Blanks

Right-click the chart
Then choose Change Chart Type

Right-click the chart > Change Chart Type

Over time: Change Chart Type > Line

Right-click chart > Change Chart Type
Choose Pie only for parts of a whole

Chart 1: Column of A1:B6
Change Chart Type > Line
Chart 2: Line of A1:B6

Section E: Spot the Error

D — You do not retype the data. Change Chart Type reuses the same data, so line 4 should be: Pick Line to show change.

C — Change Chart Title only edits the heading text. To switch from column to another type, choose Change Chart Type.

B — The Change Chart Type option appears when you right-click the chart itself, not a cell. Line 2 should be: Right-click the chart.

C — A pie chart shows parts of a whole, not change over time. A line chart suits temperature each day, so it should be: Change Chart Type to Line.

D — A line joins points and suggests change over time, which does not suit separate friends. A column chart compares categories, so line 4 should be: Pick Column to compare.