Excel Dynamic Title on Box Plot: Link It to a Cell

To make an Excel box plot title dynamic, put the title text or a formula in a worksheet cell, select the chart title, and enter a reference to that cell in the formula bar—for example, =Sheet1!$B$1. The chart title will then display the cell’s current result and update when that result changes.

What a dynamic box plot title does

A dynamic title is a chart title linked to worksheet content rather than text typed directly into the chart. The cell can contain a fixed label, a formula-built description, or text that changes in response to a selection elsewhere in the workbook. This is useful when a box-and-whisker chart is reused for different groups, reporting periods, or measures.

For example, a chart title might read “Response times — North region” when North is selected, then change to “Response times — South region” after the selection changes. The chart itself does not create that wording automatically: a worksheet cell supplies the title, and the chart displays that cell’s value.

This distinction matters because the title link changes only the displayed text. It does not change the chart’s data range, calculate new quartiles, or apply a filter. Those actions need to be handled separately, such as by changing the chart’s source data or using a control connected to the data.

Create or locate the box-and-whisker chart

In Excel for Microsoft 365 on Windows, arrange each group’s numeric observations in a separate column, with a heading at the top of each column. Select the data, then choose Insert > Insert Statistic Chart > Box and Whisker. Excel creates a box-and-whisker chart from the selected values. If the chart already exists, skip this step.

For instance, columns headed “North,” “South,” and “West” could each contain a set of delivery times. Each box summarizes the distribution in its column. Depending on the chart settings and data, Excel can display the median, quartiles, whiskers, and individual outlier points. The precise values represented by the whiskers depend on the chart’s settings; they should not automatically be described as the minimum and maximum without checking the chart options and the data.

If the chart has no title, select the chart and choose Chart Design > Add Chart Element > Chart Title > Above Chart. You can use another title placement if it suits the layout. Then click the title itself so the title box—not the chart area or a data series—is selected.

Excel for Mac has a similar chart workflow, though the ribbon labels and placement can differ slightly by release. Excel for the web may expose fewer chart-editing controls than the desktop app. If you cannot select the title and use the formula bar in your version, open the workbook in Excel for Microsoft 365 on Windows or Mac to create or adjust the link.

Link the chart title to a worksheet cell

Enter the title text in a cell, such as B1 on the sheet named Summary.
Click the chart, then click its title once. Confirm that the title is selected as an object. Do not double-click into text-editing mode.
Click the formula bar, type ='Summary'!$B$1, and press Enter. The title should now show the contents of Summary!B1.
Change the cell’s content to confirm that the title follows it.

When the worksheet name has no spaces, the reference can be shorter, such as =Sheet1!$B$1. For names containing spaces, enclose the sheet name in single quotation marks as in the example. The dollar signs make the cell reference absolute, which is a clear choice for a title link. The cell can be on the chart’s worksheet or another worksheet in the same workbook.

You can also select the cell using the mouse while the chart title is selected, but typing the reference directly into the formula bar is usually more predictable. A common mistake is typing the reference into the title’s text-editing cursor. That can make Excel treat it as literal title text rather than a linked reference. Select the title object, then use the formula bar.

Build a title that changes with a selection

A linked cell can contain a formula, not just a manually typed label. For example, suppose B1 contains the selected region and B2 contains a target expressed as a percentage. With the selected region in B1 (for example, North) and the target in B2 (for example, 0.9), put this formula in B3:

With the selected region in B1 and the target percentage in B2, enter this in B3: ="Box plot: "&B1&" | target "&TEXT(B2,"0%"). If B1 is North and B2 is 0.9, the result is Box plot: North | target 90%.

Link the chart title to B3. The title will change whenever B1 or B2 changes, because the formula in B3 recalculates. The TEXT function controls how the percentage is displayed in the combined text; without it, a decimal may appear in an unattractive or unexpected format. Adjust the wording and number format to match what the chart actually shows.

To make B1 selectable, you can create a drop-down list using Data > Data Validation, then choose a list of permitted region names. The list changes the title because B3 refers to B1. It does not, by itself, switch the box plot’s data to the selected region. To make the chart change too, arrange the chart source data or another workbook mechanism so that it responds to the same selection. A title that says “North” above unchanged data would be misleading.

Dates, measures, and useful title wording

Dynamic titles are particularly helpful when they make the chart’s scope explicit. Useful details may include the measured variable, the group or location, and the date range. For example, a title could say “Monthly order value — Online channel — Jan–Jun 2026.” Keep it concise enough to fit above the chart, and ensure every detail in it is supported by the chart’s source data.

Dates and numbers may need formatting before they are joined into a title. If a date is concatenated as an ordinary value, Excel may display its serial number rather than a readable date. Put a formula in the helper cell that uses TEXT to format the date. For example, with the report date in B2, enter ="Box plot through "&TEXT(B2,"d mmm yyyy") in B3; if B2 contains 2 November 2026, B3 displays “Box plot through 2 Nov 2026.” Link the chart title to B3.

Use the title to clarify context, not to make a statistical claim that the chart does not support. “Median delivery time by region” is suitable if the plotted values are delivery times grouped by region. “Best-performing region” is a conclusion, not a neutral description, and may not be justified by the distribution alone. A box plot can show spread and potential outliers as well as a central value, so avoid wording that hides important differences.

What updates automatically—and what does not

The linked title updates when Excel recalculates the referenced cell. If that cell contains a formula, its text can respond to a changed input, a formula result, or a selected value. The chart title is still only a display of the cell’s result. Changing the title formula does not alter the chart’s series, category labels, underlying observations, or box-plot options.

Likewise, filtering a table or changing a chart’s displayed data does not guarantee that a separately written title will describe the new view. If you want the title to identify a selected group, connect the title helper formula to the same control that drives the data view, and verify that both respond together. For a chart based on several columns, ensure the selected group actually supplies the values being plotted.

Workbook calculation settings can also affect how quickly formula-driven text refreshes. With automatic calculation enabled, formula results normally update as inputs change. If a title appears stale, check Formulas > Calculation Options and confirm that calculation is set to Automatic, or recalculate the workbook. A chart title linked to a cell is not a substitute for checking that the cell’s formula returns the intended result.

Formatting and managing the helper cell

Format the chart title using the chart tools after establishing the link. You can select the title and change its font, size, color, alignment, or position. The linked cell controls the title’s text; it does not require the chart title to copy the cell’s font or fill formatting. This separation lets you keep a tidy helper area without making the chart title inherit worksheet styling.

Put helper formulas near the data or on a clearly named report sheet, and label them so another workbook user can understand their purpose. You may hide a helper column or place the formula on a dedicated sheet, but do not delete the referenced cell: the chart will lose its title content or display an error if its source reference becomes invalid. Hiding the sheet or cell does not normally prevent the chart from reading the cell, but test the workbook after reorganizing it.

If a chart is copied to another workbook, review its title reference. A copied chart may continue pointing to the original workbook or may need its source links updated, depending on how it was copied and what references it uses. Check the formula bar with the title selected and verify the displayed title after saving and reopening the destination file.

Common problems and quick fixes

The title shows the reference literally: Select the title object rather than editing its text, then enter the cell reference in the formula bar and press Enter.
The formula bar is unavailable or the chart title is not selected: Click the title once, not the plot area. If there is no title, add one through Chart Design > Add Chart Element > Chart Title.
The title is blank: Check whether the source cell is empty or its formula returns an empty string. Also check for a broken sheet or cell reference.
The title contains an error: Inspect the helper-cell formula first. A chart title displays the cell result; it cannot repair an error produced by that formula.
The title does not change after selecting a new group: Confirm that the selection control changes the cell referenced by the helper formula, and that the chart’s data responds to the same selection if the chart itself should change.
The title is cut off: Widen the chart, shorten the wording, or adjust the title font size. Long text in a cell can be readable on the sheet but still exceed the chart’s available title space.

When to use a linked title instead of alternatives

A linked chart title is usually the simplest option when the title is a single line of text that should update with a cell. It stays attached to the chart and moves with it. It is also easy to maintain: edit the helper-cell formula or its inputs rather than editing the chart every time.

A manually typed chart title is more appropriate when the wording is fixed and will not change. A text box can offer more layout freedom, but it is a separate object and may not move or resize with the chart unless you position and manage it carefully. If you use a text box, remember that it needs its own cell link if you want the same dynamic behavior; typing a formula into the visible text area is not the same as linking the object through the formula bar.

For a report with several charts, a consistent pattern helps: use a clearly named selection cell, a helper formula that states the chart’s scope, and a title linked to that formula. This makes it easier to audit whether the title, selected category, and plotted data agree. A dynamic title improves clarity, but it does not validate the underlying measurements or replace a proper review of the chart.

Frequently Asked Questions

Can an Excel chart title be linked to a cell?
Yes. Select the chart title, enter a reference such as =Sheet1!$B$1 in the formula bar, and press Enter. The title displays the referenced cell’s value.

Can a box plot title change from a drop-down list?
Yes, if the drop-down changes a cell used by the title formula. If the plotted data should change as well, connect the data view to that same selection; the title link alone does not filter the chart.

Can the linked title come from another sheet?
Yes. Reference the cell on the other sheet, using single quotation marks around a sheet name that contains spaces, such as ='Summary Data'!$B$1.

Why does my chart title show the formula instead of its result?
The chart title may be in text-editing mode, or the reference may have been typed into the title rather than the formula bar. Select the title as an object, enter the reference in the formula bar, and press Enter.

Does changing the title change the box plot’s data?
No. It changes only the displayed title. Update the chart’s source data or filtering setup separately, and make sure the title accurately describes the values currently plotted.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.