Link chart title and cell value in Excel

For example, for the Chart below, I would like to add a Title that is linked to Data Table Title ("Daily Sales - Wk 35") so that I do not have to edit the Chart Title every week.

excel link chart title and cell value

To do it in Excel, here is the answer:

a) Click on Chart. "Chart Tools" tab appears in ribbon. Under "Chart Tools", Click on Layout -> Chart Title -> Above Chart as shown below.

excel link chart title and cell value

b) After step above, a Text box "Chart Title" appears as shown below. Select the Text Box and in the formula bar enter "=" and then select the Data Table title cell (cell BT2 in this case). Click Enter.

excel link chart title and cell value

c) After step above, "Chart Title" is now linked to the Data Table title cell (cell BT2 in this case) and displays the same value as in cell.

excel link chart title and cell value

 

You can find similar Excel Questions and Answer hereunder

1) Is there a way to create an visually impactful report with stop lights indicating automatically if Target is met?

2) How can I identify all cells with Data Validation in my WorkSheet?

3) How can I enter a cent symbol in a cell?

4) How can I ensure that user enters only certain acceptable values in an input cell?

5) How can I find the slab in which a given value fits?

6) How can I identify the cells that influence a particular cell to help with debugging of my spreadSheet or understand a spreadSheet that I inherited?

7) How do I find the median salary of employees with the same skillset in my Organization?

8) How can I get the last non-zero value in a row?

9) How do I know which cells on the worksheet contain Conditional Formatting?

10) How do I enter a formula in a cell using VBA (using Relative Reference)?

 

Here the previous and next chapter