You can easily reference a cell in a chart title or axis label in Excel to make your chart dynamic and update automatically when the cell value changes. Here's how:

1. Click on the Chart Title or Axis Label: Select the specific title or label you want to link to a cell.
2. Access the Formula Bar: There are two ways to access the formula bar:
- Double-click on the title or label: This will open a text box where you can edit the content and access the formula bar.
- Right-click on the title or label and choose "Edit Text": This will also open a text box for editing.
3. Enter the Formula: In the formula bar, type an equal sign (=) followed by the cell reference you want to link. For example, to display the value in cell B3 in your chart title, you would enter: `=B3`.
4. Press Enter: Once you've entered the formula, press the Enter key to apply the link.

Additional Tips:

* You can use any valid cell reference, including sheet names (e.g., `=Sheet1!A1`).
* You can combine text with cell references to create more descriptive titles or labels. For example: `="Sales in " & B2` would display "Sales in" followed by the value in cell B2.
* To format the linked cell value within the title or label, you can use formatting codes after the cell reference. For example, `=B3"%"` would display the value in B3 with a percent sign.

By referencing cells in your chart titles and labels, you can create more informative and dynamic charts that automatically update with your data.