← VCE Spreadsheets, SQL & Visualisation

Spotting misleading charts

A chart whose design, like a cut-off axis, 3D effects or a cherry-picked range, makes the data look different from what it truly shows.

Part of: VCE Applied Computing - U1O1 - Data analysis — Module 68, VCE Data Analytics - U3O1 - Data Analytics — Module 127, VCE Data Analytics - U4O1 - Development and Evaluation — Module 87, 7-8 Digital Technologies: Analysing and visualising data — Module 26, ACARA Digital Technologies Years 7–8 — Analysing and Visualising Data — Module 46, ACARA Digital Technologies Years 9–10 — Acquiring and Validating Data — Module 119, ACARA Digital Technologies Years 9–10 — Analysing and Visualising Data — Module 37

Understanding Spotting misleading charts in VCE Spreadsheets, SQL & Visualisation

What it does: Showing only part of the data hides the full story, so the chart looks different from what all the data shows. An axis that begins at zero keeps bar heights in proportion to the real values, so the chart is honest. A cut-off axis stretches small gaps. 96 and 100 are close, but the bars look very different in height. 3D effects distort size. The slices closer to the viewer look bigger, even if their values are the same or smaller. Missing labels and numbers make it hard to know the real values. Clear titles and labels help you read data honestly.

Common mistakes: Starting the y-axis at 50 cuts off the bottom of the columns, so small differences look huge. A fair column chart starts at 0: y_axis_start = 0. A 3D tilt makes bars at the front look bigger than bars at the back, so it is hard to compare them fairly. It should be a flat 2D effect: effect = "flat 2D".

Class: _____________________ · Name: _____________________ · Date: _________

Free printable worksheet with full answer key — or add this module to a class and your students practise it interactively.

🖨 Print worksheet + answer key Add Spotting misleading charts to a class →

This module's key terms are also in a printable crossword (Modules 55–70) and word search (Modules 55–86).

Take this worksheet further — free with Cloodit

Each concept is reinforced from every angle — learned, then applied, then tested.

Learning

Duo

A column chart's y-axis starts at 95 instead of 0. Two bars show 96 and 100. What does this do?

Makes a small difference look hugeShows the true size of the difference

Matches

Bar chart: axis runs 95 to 100, scores 96 and 99

↓

The axis does not start at zero, so a tiny 3-point difference looks like one bar is several times taller. Fix: start the axis at 0.

Applying

Meanings

Term

misleading chart

Meaning

A chart whose design, like a cut-off axis, 3D effects or a cherry-picked range, makes the data look different from what it truly shows.

Practice

IF axis_min <> 0 THEN

Testing

Gaps

Column chart: Y-axis minimum =

Check Answer

Spots

2title = "Cans collected by class"

3y_axis_start = 50

Cloodit turns curriculum-aligned coding content into journeys students work through one biome at a time.

Students earn collectable badges

Over 100 of them, across seven natural biomes.

Study Buddy

Students build a real study resource

Turns their work into revision material ready for Flash Cards and Exam study.

Diamond Dash — one of Cloodit's live, competitive Sprint games

Students lock in with Sprints

Live, competitive practice for the start of the lesson or a teacher-led lesson finisher.

A Cloodit certificate of achievement, ready to personalise and print

Custom printable certificates

Honour your top performers, or encourage a student who's trying hard — ready to print in seconds.

Add to class →

Quick Questions

1. A column chart's y-axis starts at 95 instead of 0. Two bars show 96 and 100. What does this do?

A. Shows the true size of the difference

B. Makes a small difference look huge ✓

A cut-off axis stretches small gaps. 96 and 100 are close, but the bars look very different in height.

2. Which chart is more honest about the size of a difference between two bars?

A. A bar chart whose axis starts at 90

B. A bar chart whose axis starts at 0 ✓

Bars show size by their length, so the axis should start at zero. Otherwise the bars exaggerate the gaps.

3. A pie chart is tilted in 3D so the front slice looks bigger than the back slice. Why is this misleading?

A. The slice nearest you looks larger than it really is ✓

B. 3D makes every slice the correct size

3D effects distort size. The slices closer to the viewer look bigger, even if their values are the same or smaller.

4. A line graph shows only the 3 best weeks of a school canteen's sales out of 20 weeks. This is an example of...

A. A cherry-picked range ✓

B. A fair sample of all the data

Cherry-picking means choosing only the part of the data that supports one story and hiding the rest.

5. Which is a warning sign that a chart might be misleading?

A. The axis has no labels or numbers ✓

B. The chart has a clear title and labelled axes

Missing labels and numbers make it hard to know the real values. Clear titles and labels help you read data honestly.

Match the Pairs

Y-axis starts at 90, not 0 → A truncated axis that makes small differences between bars look huge

3D pie chart tilted back → A 3D effect that makes slices at the front look bigger than they really are

Choosing only the good weeks to show a rise in sales is a cherry-picked range → x-axis: Weeks 8 to 10 only (Weeks 1 to 7 left out)

To show differences fairly, bars should start from zero → Y-axis: 0, 20, 40, 60, 80, 100

Bar chart: axis runs 95 to 100, scores 96 and 99 → The axis does not start at zero, so a tiny 3-point difference looks like one bar is several times taller. Fix: start the axis at 0.

Line chart: no title, no axis labels, no units → Missing labels mean the reader cannot tell what the data measures, so they may read it wrongly. Fix: add a title, axis labels and units.

Key Term

misleading chart

A chart whose design, like a cut-off axis, 3D effects or a cherry-picked range, makes the data look different from what it truly shows.

Fill in the Blanks

1. Column chart: Y-axis minimum = 0

Hint: Type the starting value an honest column chart axis should use.

2. Chart style: 2-D column

Hint: Type the style that avoids 3D effects that distort bar sizes.

3. Data: B2:B13 (Jan-Dec) Chart range: B2:B13

Hint: Type the last cell so the chart shows every month, not a cherry-picked part.

4. Axis steps: 10, 20, 30, 40

Hint: Type the number that keeps the scale even instead of uneven.

5. Add: Chart Title, Axis Titles, Legend

Hint: Type the chart element that names what each axis measures, so labels are not missing.

Spot the Error

Question 1

A chart = "column"

B title = "Cans collected by class"

C y_axis_start = 50

D y_axis_label = "Cans"

Line C — Starting the y-axis at 50 cuts off the bottom of the columns, so small differences look huge. A fair column chart starts at 0: y_axis_start = 0.

Question 2

A chart = "bar"

B title = "Canteen sales"

C effect = "3D tilt"

D labels = "on"

Line C — A 3D tilt makes bars at the front look bigger than bars at the back, so it is hard to compare them fairly. It should be a flat 2D effect: effect = "flat 2D".

Question 3

A chart = "line"

B title = "Daily steps in 2024"

C x_start = "Jan"

D x_end = "Feb"

Line D — The title says the whole of 2024, but ending at Feb is a cherry-picked range that hides the rest of the year. The x-axis should end at Dec: x_end = "Dec".

Question 4

A chart = "line"

B y_min = 0

C y_step = "10, 20, 50, 100"

D y_label = "Points"

Line C — An uneven scale squashes some changes and stretches others, which distorts the shape of the line. The steps should be equal: y_step = 10.

Question 5

A chart = "column"

B y_label = ""

C x_label = "Month"

D title = "Pizza prices"

Line B — A missing y-axis label means readers cannot tell what the numbers measure or what units they use. It should say what is measured: y_label = "Cost ($)".

Student with a class code? Join your class →