Excel Chart Dynamic Title: Link It to a Cell

To make an Excel chart title dynamic in Microsoft 365 for Windows, put the title text or a formula in a worksheet cell, select the chart title, type a reference to that cell in the formula bar, and press Enter. The title will then reflect changes to the linked cell, so you can update a chart heading by changing a label, date, or selection on the sheet.

What a dynamic chart title does

A standard chart title is text that you type into the chart. It stays the same until you edit it. A dynamic title is linked to a worksheet cell, so Excel displays that cell’s current result as the chart title. The cell can contain ordinary text or a formula that assembles text from other cells.

This is useful when a chart is reused for different reporting periods, regions, products, or scenarios. Instead of changing the title by hand each time, you can change the inputs in the worksheet and let the linked cell update. The chart title does not choose the data for the chart or change the chart’s underlying series; it changes only the displayed heading.

One important distinction: you do not enter a worksheet formula by typing directly into the chart title as if it were a cell. You select the title and enter a cell reference in Excel’s formula bar. That reference creates the link.

Link a chart title to a cell

First, make sure the chart has a title. Select the chart, then choose Chart Design > Add Chart Element > Chart Title > Above Chart. If a title is already present, select it instead. The title should show selection handles, indicating that the title object—not the whole chart—is selected.

Enter the title you want in a worksheet cell. For example, use a cell on the chart’s data sheet or a dedicated dashboard sheet.
Click the chart once, then click the chart title so only the title is selected.
Click the formula bar. If it is hidden, turn it on from View > Formula Bar.
Type an equals sign and the cell reference. With the title cell in B2 on a sheet named Dashboard, enter =Dashboard!$B$2.
Press Enter on Windows, or Return on Mac. The chart title should now display the contents of Dashboard!B2.

When the worksheet name contains spaces, enclose it in apostrophes in the reference. For a title cell in B2 on a sheet named Monthly Report, use ='Monthly Report'!$B$2. The dollar signs make the row and column absolute, which is helpful if you later copy the reference or move related worksheet content. You can also click the target cell while the chart title is selected; Excel will insert a reference for you.

Build the title text in a worksheet cell

A linked cell can contain a formula, which makes the heading dynamic without requiring a complicated chart setup. For example, a dashboard might have a selected month in B2 and a region name in C2. Put the following formula in D2, the cell that will supply the chart title:

With the selected month in B2 and the region in C2, enter this in D2: ="Revenue - "&TEXT(B2,"mmmm yyyy")&" - "&C2. If B2 contains 1 November 2026 and C2 contains West, the result is Revenue – November 2026 – West.

Then link the chart title to D2. When the month or region changes, D2 recalculates and the chart title follows. The TEXT function is useful because dates are stored as numbers in Excel; without TEXT, joining a date to words can produce a serial number rather than a readable month. The format code mmmm yyyy displays a full month name and year. Choose a different format, such as mmm yyyy, if a shorter label fits your chart better.

Concatenation with the ampersand is often enough for a short heading. You can also build the title from a report name, a selected category, and a unit label. Keep the resulting text concise: a title that is technically dynamic can still become difficult to read if it includes too many details.

Choose a good source cell

The linked cell can sit beside the chart, on the same worksheet, or on a separate worksheet. For a dashboard, it is often clearer to keep the title formula near the selection controls and give it a descriptive label. A title formula cell is still a normal worksheet cell: it can be formatted, inspected, and used by other formulas, but the chart title displays its calculated value rather than its formula.

Plan for the cell’s possible results before linking it. Consider these practical points:

Use readable labels. A chart title should describe what the viewer is seeing, not expose a cell address, code, or internal field name.
Keep date formatting deliberate. Use TEXT when a date is joined to other text, and choose a format that suits the report’s audience.
Consider empty selections. If a control cell can be blank, decide whether the title should show a general heading or an incomplete label.
Check the longest possible title. A heading that fits for one region may wrap or crowd the chart when a longer category is selected.
Keep the source stable. Avoid deleting or replacing the linked cell as the workbook is reorganized; doing so can break the title reference.

If the title should show a general label when C2 is empty, a formula can test that condition. With the month in B2 and the optional region in C2, put this in D2: =IF(C2="","Revenue - "&TEXT(B2,"mmmm yyyy"),"Revenue - "&TEXT(B2,"mmmm yyyy")&" - "&C2). If C2 is blank and B2 contains 1 November 2026, the result is Revenue – November 2026; if C2 contains West, the result is Revenue – November 2026 – West.

Keep the title readable and consistent

After the link works, format the chart title as you would a regular chart title. Select it and use the Home tab for font, size, color, and emphasis. You can also drag the title within the chart area, depending on the chart layout. These formatting choices affect the title object; they do not change the source cell or its formula.

Excel may adjust the title’s appearance as the chart is resized, but it does not automatically guarantee that every possible title will fit. Test the chart with the longest expected month, region, or product name. If the heading is too wide, shorten its wording, use an abbreviation that readers understand, widen the chart, or move some detail into a subtitle or nearby text box. Keep in mind that a chart title linked to one cell displays that cell’s value; it does not combine multiple lines of cell formatting or reproduce the source cell’s font styling.

For accessibility and clarity, make the title meaningful outside the immediate context of the worksheet. “West” may be enough when the dashboard clearly labels the metric, but “Monthly revenue – West” is more informative when the chart might be copied into a presentation or viewed on its own.

What changes—and what does not

The link updates the chart title when the referenced cell’s displayed value changes. That may happen because someone edits the cell, changes a dropdown selection used by a formula, or changes data that the title formula depends on. The title follows Excel’s calculation behavior; if calculation is set to Manual, dependent formulas may not refresh until the workbook recalculates.

The link does not automatically make every part of the chart dynamic. The chart’s data range, axis labels, legend, and series names are controlled separately. If the chart data changes but the title cell does not, the heading can become misleading. Likewise, a title formula that refers to a filter selection does not itself filter the chart. Make sure the data-selection logic and title logic use compatible inputs.

A title linked to a cell also does not display the cell’s formatting. For instance, if the cell is formatted with a particular font color or date display, the chart title will not inherit those cell-level styles. Format the chart title separately, and use TEXT in the source formula when you need a specific date or number representation in the text.

Common problems and fixes

The title shows the formula or reference as text. Confirm that the chart title itself is selected, then enter the reference in the formula bar and press Enter. Typing into the title’s text-editing area is not the same as entering a formula reference.
The whole chart moves or resizes. Click the title a second time so only the title object is selected. A single click usually selects the chart; a further click on the title selects the title.
The reference returns an error. Check the worksheet name and cell address. Sheet names containing spaces need apostrophes, as in ='Monthly Report'!$B$2. Also make sure the source cell still exists.
A date appears as a number. Use TEXT in the source cell formula to convert it to a chosen readable display, such as a month and year.
The title does not update after an input changes. Check that the source formula actually depends on that input and that Excel calculation is not set to Manual. You can recalculate a workbook with F9 on Windows; Mac keyboard behavior can depend on the keyboard’s function-key settings.
The chart has no title to select. Add one through Chart Design > Add Chart Element > Chart Title, then link it to the source cell.

Dynamic cell link versus a manually edited title

A manually edited title is a good choice for a fixed chart: it is quick, easy to understand, and does not depend on another cell. A cell-linked title is better when the chart is reused or controlled by changing worksheet inputs. It reduces repetitive editing and helps keep a dashboard heading synchronized with its selected period or category.

The trade-off is that the link adds a dependency. A reader maintaining the workbook needs to know which cell supplies the title, and that cell must remain available. For a shared workbook, label the source cell or keep the title formula in a clearly organized area. Neither approach is universally better; choose based on whether the chart heading is truly expected to change.

Frequently Asked Questions

Can an Excel chart title use a formula?
Yes. Put the formula in a worksheet cell, then select the chart title and enter a reference to that cell in the formula bar. The title displays the formula cell’s result.

Can I link a chart title to a cell on another sheet?
Yes. Include the sheet name in the reference, such as =Dashboard!$B$2. If the sheet name contains spaces, surround it with apostrophes, as in ='Monthly Report'!$B$2.

Why does my dynamic chart title show a date number?
Excel stores dates as serial values. When joining a date with text, wrap the date reference in TEXT and specify a display format, such as mmmm yyyy.

Can a chart title update from a dropdown list?
Yes. Link the title to a cell that contains the dropdown selection or to a formula cell that uses that selection. The chart title updates when the resulting cell value changes, provided the workbook recalculates.

Does a dynamic title change the chart data?
No. It changes only the title text. Configure the chart’s data source, filters, and series separately, and ensure the title accurately describes the data currently shown.

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.