1. Click on the chart to select it.
2. Click on the chart title to select it.
3. In the formula bar at the top of the Excel window, type the following formula:
   Formula:

   ="Text " & A1 

   
   (Note: replace A1 with the cell reference that you want to include in the title.)
4. Press Enter to apply the formula to the chart title.

This formula uses the ampersand (&) symbol to concatenate the text "Text " with the contents of cell A1. You can replace "Text " with any other text that you want to include in the title.

Once you have applied the formula to the chart title, it will display the concatenated text and cell reference. If the contents of cell A1 change, the chart title will update automatically to reflect the new value.