Excel Chart Title Formula: Link a Title to a Cell

To make an Excel chart title dynamic, select the chart title, click the formula bar, enter a reference to a worksheet cell, and press Enter. If the title needs to combine text, dates, or values, first build it with a worksheet formula, then link the chart title to that cell.

What an Excel chart title formula does

A chart title normally contains text that you type into the chart. Linking it to a cell changes that behavior: the title displays the cell’s current value and updates when the cell changes. This is useful for dashboards, recurring reports, and charts whose descriptions depend on a selected period or data total.

The link itself is a reference to one cell, not a formula that you type directly into the chart title’s text. For example, with the title text stored in cell A1 on a worksheet named Sheet1, the chart-title link is =Sheet1!$A$1. Select the chart title before entering that reference in the formula bar. Excel then displays the cell’s contents as the title.

The dollar signs make the row and column absolute in the reference. They are helpful if the worksheet formula is copied elsewhere, but they are not essential to a chart title link. A cell reference can also point to another worksheet in the same workbook.

Link a chart title to a cell in Excel for Microsoft 365

In Excel for Microsoft 365 on Windows, create or select a chart and make sure it has a title. If no title is visible, use Chart Design > Add Chart Element > Chart Title > Above Chart. Then link the title as follows:

Click the chart title once so Excel selects the title object. Avoid clicking a second time in a way that puts the insertion point inside the title text.
Click in the formula bar above the worksheet grid. If it is hidden, enable Formula Bar from the View tab.
Type a reference to the cell that contains the desired title. With the title in A1 on Sheet1, enter =Sheet1!$A$1.
Press Enter. The chart title should now show the referenced cell’s contents.

Check that the title object, rather than a data point or the chart area, is selected before typing. If the formula appears in a worksheet cell instead, the chart title was not selected. Click the title once and try again. The chart title can still be formatted after linking: select it and use the usual font, size, color, and alignment controls.

In Excel for Microsoft 365 on Mac, the same basic method is available: select the chart title, enter the cell reference in the formula bar, and press Return. Excel for the web can edit chart titles, but if the formula-bar linking workflow is unavailable in your browser, open the workbook in the desktop app to create the link.

Build a title with a worksheet formula

To combine a fixed label with a changing value, create the complete title in a worksheet cell. For example, suppose A2 contains the text North Region and B2 contains the number 125000. With those values in A2 and B2, enter this formula in C2:

=A2&" — "&TEXT(B2,"$#,##0")

It returns North Region — $125,000 in an English-language Excel setup using that number format. Link the chart title to C2 using the title-selection and formula-bar steps above. When either source cell changes, the title formula recalculates and the chart title follows it.

The TEXT function is useful when the value should have a particular display format. Without it, a number included in a text combination may not appear with the currency symbol, thousands separators, or decimal places you expect. The format string shown is illustrative; a workbook’s regional settings and reporting requirements may call for a different currency symbol or number format.

For a title that combines a period label and a measure, suppose A1 contains the word Sales and B1 contains a date stored as an Excel date value. Put the following formula in C1:

=A1&" for "&TEXT(B1,"mmmm yyyy")

With A1 set to Sales and B1 set to a date in March 2025, the result is Sales for March 2025. Link the chart title to C1. This method is often more reliable than putting a date directly in a title cell, because Excel can display the date in the readable month-and-year format you choose.

Use worksheet names and references correctly

If the source cell is on the active worksheet, a reference such as =$A$1 can be sufficient. To avoid ambiguity, a sheet-qualified reference is clear and works when the chart is on a different worksheet. For a sheet named Monthly Report with the title in D1, use ='Monthly Report'!$D$1. Excel requires apostrophes around a worksheet name that contains spaces or certain special characters.

A reference should point to one cell. You cannot link a chart title to a range and expect Excel to combine the range’s values into a single title. If you need text from several cells, combine it in a helper cell with a worksheet formula, then link the chart title to that helper cell.

Keep the helper cell in the same workbook as the chart. For a chart that must travel between sheets or be copied into another workbook, check the link afterward: references can continue pointing to the original worksheet or workbook, or need updating, depending on how the chart and cells are moved.

Make titles respond to filters and report controls

A linked title updates when its source cell recalculates. That can make a report easier to interpret when a worksheet control, input cell, or formula changes the reporting period or category. For instance, a title cell might combine a label with the value selected in a dropdown. The chart title itself does not read the dropdown directly; it reflects the formula result in the linked cell.

This distinction helps when diagnosing a title that does not change. Follow the chain: confirm the input or selection has changed, check that the helper formula returns the new text, and then confirm the chart title points to the helper cell. If the helper cell updates but the chart title does not, reselect the title and inspect its formula-bar reference.

For PivotCharts and charts controlled by slicers, do not assume the chart title automatically describes the current filtered view. A title linked to a worksheet cell changes only according to that cell’s value. If the title needs to name the active selection, make sure the worksheet formula or report process actually supplies that selection to the linked cell.

Common problems and practical fixes

The reference appears as literal title text. The title may have been edited as text instead of selected as a chart object. Click the title once, then enter the reference in the formula bar.
The formula bar entry changes a worksheet cell. The chart title was not selected when you began typing. Undo the unintended cell edit if needed, select the title, and repeat the process.
The title is blank. Check whether the linked cell is empty or whether its formula currently returns an empty string. Also confirm that the reference points to the intended sheet and cell.
The title shows an unexpected number or date. The chart displays the cell’s value as Excel resolves it. Create a helper formula using TEXT when you need explicit date, currency, or decimal formatting.
The title does not update. Check that the linked cell’s contents have changed and that calculation is current. Also verify the chart title is still linked to the intended cell rather than having been replaced with manually typed text.
The title is clipped or wraps awkwardly. The link may be correct, but the chart is too small for the text. Widen the chart, shorten the helper-cell text, or adjust the title’s font and placement.

A chart title link controls the title’s content, not its appearance. Font styling, placement, and chart size remain separate formatting choices. Likewise, linking a title does not automatically add units, explain an unusual scale, or identify a filtered subset unless that information is part of the linked cell’s text.

Cell link versus manually typed title

A manually typed title is simplest when the wording is fixed and will not need to change with the data. It avoids a helper cell and is easy to edit directly on the chart. The drawback is that someone must remember to update it when the reporting period, measure, or scope changes.

A cell-linked title is better when the title should follow a report input or formula. It keeps the wording in the worksheet, where it can be reviewed alongside the data, and can reduce inconsistencies across recurring reports. It does add a dependency: if the source cell is changed, cleared, or moved, the chart title may no longer say what you intend.

For a calculated title, the most maintainable setup is generally a helper cell with a readable formula and a chart linked to that cell. This separates the work into two clear parts: the worksheet produces the wording, and the chart displays it. It is also easier to troubleshoot than trying to manage a long description as manually edited chart text.

Frequently Asked Questions

Can I type a formula directly into an Excel chart title?
No. To link a title, select the chart title and enter a reference to one cell in the formula bar. Put a longer formula in a worksheet cell first, then link the title to that cell.

What is the formula for linking a chart title to a cell?
With the title stored in A1 on Sheet1, use =Sheet1!$A$1 in the formula bar while the chart title is selected. If the worksheet name contains a space, surround it with apostrophes, as in ='Monthly Report'!$D$1.

Can a chart title combine text and a cell value?
Yes. Combine the text and value in a worksheet formula, using TEXT when you want a particular number or date format. Then link the chart title to the cell containing the formula result.

Why does my chart title show the formula instead of the result?
Make sure you entered a cell reference in the formula bar with the chart title selected. A formula typed into the title’s text-editing area may be treated as title text rather than as a link. For calculated wording, use a helper cell.

Will a linked chart title update automatically?
It updates when the referenced cell’s displayed value changes. If that cell contains a formula, the title follows the formula result after Excel recalculates it. A title linked to a fixed text value will not change until that cell is edited.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.