Link a Chart Title to a Cell

Excel Formulas › Charts

All versionsLinked title

A chart title that updates itself. Build the title text in a cell with a formula, then link the chart’s title to that cell — so it always reflects the latest numbers, period, or filter.

Quick formula: build the title in a cell, then link it:
A1: ="Sales — "&TEXT(SUM(data),"$#,##0")&" ("&period&")"
Click the chart title, type = in the formula bar, click cell A1, press Enter. The title now mirrors A1.

Functions used (tap for the full reference guide):

TEXT

The example

A title cell that rebuilds from the data.

A
1Title cell (A1)
2Sales — $84,200 (Q2 2026)

The formula

Compose the title, then point the chart at it:

A1: ="Sales — "&TEXT(SUM(B2:B13),"$#,##0")&" ("&D1&")" Chart title → formula bar → =Sheet1!$A$1 // title updates with the data

How it works

Two parts: a formula title cell, and a link:

  1. In a cell, build the title with text and formulas: ="Sales — "&TEXT(SUM(data),"$#,##0")&" ("&period&")".
  2. Click the chart title once to select it.
  3. In the formula bar, type =, click the title cell, and press Enter.
  4. The chart title now shows the cell’s text and refreshes whenever the formula recalculates.

The same trick works for axis titles and text boxes. Select the element, type = in the formula bar, and click a cell. Great for dashboards where a slicer or dropdown changes what’s shown.

Try it: interactive demo

Live demo

Edit the values; the title rebuilds.

Title:

Variations

Include a date

Auto-stamp:

="As of "&TEXT(TODAY(),"mmm d, yyyy")

Show % change

Trend in the title:

="Sales "&TEXT(chg,"+0%;-0%")&" vs LY"

Axis title link

Same steps on an axis title.

Pitfalls & errors

Type = in the formula bar, not the title. Editing the title text directly just types literal characters. Select the title, then use the formula bar.

Use an absolute reference. The link should be =Sheet1!$A$1 so it doesn’t drift.

One cell only. A linked title points to a single cell — build the whole string there, not across several cells.

Practice workbook

📊
Download the free Link a Chart Title to a Cell practice workbook
A chart with a formula-built linked title, the date and %-change variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I link a chart title to a cell in Excel?
Build the title text in a cell, click the chart title, type = in the formula bar, click the cell, and press Enter. The title mirrors the cell.
How do I make a chart title update with the data?
Put a formula in the title cell, e.g. ="Sales — "&TEXT(SUM(data),"$#,##0"), then link the title to that cell. It refreshes on recalc.
Can I link axis titles too?
Yes — the same trick works for axis titles and text boxes: select the element, type = in the formula bar, and click a cell.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: Join text · Dynamic chart source · TEXT formatting

Function references: TEXT