← ACARA Digital Technologies Years 9–10

A chart title linked to a cell

A chart title linked to a cell. Click the title, type = then a cell or text joined with &, and the title updates when the cell changes, such as a drop-down choice.

Part of: ACARA Digital Technologies Years 9–10 — Analysing and Visualising Data — Module 67

Understanding A chart title linked to a cell in ACARA Digital Technologies Years 9–10

What it does: The text in quotes stays the same, and & adds the current value of B1 so the title updates when the choice changes. After clicking the title and typing = followed by the cell, the title is linked and follows that cell. Without the = at the start, the text is just typed words, so it will not link to any cell. The & is the join (concatenate) operator. It sticks text and values together, so you get Sales for Maths, for example. Select the title first, then type = and click or name the cell it should show. Text in a formula must be wrapped in quotes before it is joined to a cell with &.

Common mistakes: Without the = sign, the chart title shows the plain text D1 and is not linked to the cell. It should be: Type =D1 and press Enter. Text and a cell are joined with the & operator, not +. Using + gives a #VALUE! error. It should be: Type ="Marks for "&B1.

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 A chart title linked to a cell to a class →

This module's key terms are also in a printable crossword (Modules 413–424) and word search (Modules 413–451).

Take this worksheet further — free with Cloodit

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

Learning
Duo
How do you link a chart title to a cell?
Double-click the title and type the cell name as plain textClick the title, type = then click the cell
Matches
=Sales for &B1
↓
The fixed text is missing quotation marks, so the formula is invalid. It should be ="Sales for "&B1
Applying
Meanings
Term
="Sales for "&B1
Meaning
A chart title linked to a cell. Click the title, type = then a cell or text joined with &, and the title updates when the cell changes, such as a drop-down choice.
Practice
="Chart of "&B1&" results"
Testing
Gaps
"Sales for "&B1
Check Answer
Spots
3Click the chart title
4Type D1 and press Enter

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

The 'Cheetah' badge — Savannah Sprinter, one of Cloodit's 106 collectible badges
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. How do you link a chart title to a cell?
A. Click the title, type = then click the cell ✓
B. Double-click the title and type the cell name as plain text
Starting with = tells the spreadsheet the title is a link, so it shows whatever is in that cell and updates when the cell changes.
2. Which title formula joins text with the value in B1?
A. ="Sales for "&B1 ✓
B. ="Sales for "+B1 as plain text
The & symbol joins text and a cell value together. Typing the text without an = just gives a fixed title.
3. A chart title is linked to cell B1, and B1 changes from Maths to Science. What happens to the title?
A. It stays showing Maths until you retype it
B. It updates to show Science ✓
A linked title follows its cell, so it updates automatically whenever the cell changes.
4. Why would you link a chart title to a drop-down list cell?
A. So the title matches the option the user picks ✓
B. So the drop-down list can be deleted
When the chart is driven by a drop-down choice, a linked title always names the data currently shown.
5. Which one will NOT make a linked title?
A. Typing =Sheet1!B1 in the title bar
B. Typing Sales for B1 in the title box ✓
Without the = at the start, the text is just typed words, so it will not link to any cell.

Match the Pairs

="Sales for "&B1 → Joins the words Sales for with whatever is in cell B1, so a linked chart title can change when B1 changes
=Sheet1!$B$1 → Links the chart title straight to cell B1, so the title shows exactly what that cell says
To join fixed text and a drop-down choice in cell B1 into one title, use the & operator → ="Results for "&B1
To link a title to a cell, click the chart title, then type = and the cell address in the formula bar → =Sheet1!B1
=Sales for &B1 → The fixed text is missing quotation marks, so the formula is invalid. It should be ="Sales for "&B1
="Sales for "+B1 → The + sign is used instead of & to join text, so it gives an error. It should be ="Sales for "&B1

Key Term

="Sales for "&B1
A chart title linked to a cell. Click the title, type = then a cell or text joined with &, and the title updates when the cell changes, such as a drop-down choice.

Fill in the Blanks

1. ="Sales for "&B1
Hint: Type the symbol you enter first after clicking the chart title to make it a formula.
2. ="Sales for "&B1
Hint: Type the operator that joins the text and the cell value together.
3. // Drop-down choice is in cell B1 ="Sales for "&B1
Hint: Type the cell reference holding the drop-down choice, as the comment says.
4. ="Rainfall for "&B1&" this week"
Hint: Type the joining operator that adds more text after the cell reference.
5. // Selected day is in cell C3 ="Weather for "&C3
Hint: Type the cell reference that holds the selected day, so the title updates when it changes.

Spot the Error

Question 1
A B1: Hobart
B D1: ="Rain in "&B1
C Click the chart title
D Type D1 and press Enter
Line D — Without the = sign, the chart title shows the plain text D1 and is not linked to the cell. It should be: Type =D1 and press Enter.
Question 2
A B1: Maths
B Click the chart title once
C Type ="Marks for "+B1
Line C — Text and a cell are joined with the & operator, not +. Using + gives a #VALUE! error. It should be: Type ="Marks for "&B1
Question 3
A B1: Hobart
B D1: =Rain in &B1
C Select the chart title
D Type =D1 then press Enter
Line B — Fixed text in a formula must be wrapped in double quotes. It should be: D1: ="Rain in "&B1
Question 4
A B1: Hobart
B D1: ="Rain in "&B1
C Click the chart title
D Type =Sheet1.D1, press Enter
Line D — A reference to a cell on a sheet uses an exclamation mark, not a full stop. It should be: Type =Sheet1!D1, press Enter
Question 5
A B1: Year 9
B D1: ="Marks for "&B1
C Click axis, type =D1, Enter
Line C — The link must be made on the chart title. Clicking an axis title or label would link the wrong element. It should be: Click title, type =D1, Enter

Student with a class code? Join your class →