link chart title and cell value in Excel

Q49. In Excel, how can I add and link a Chart Title to a cell value?

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 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 excel 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 excel excel excel link chart title and cell value

 

You can find similar Excel Questions and Answer hereunder

1) How can I clear cell after activating a routine when there is a change in value of a cell?

2) I have a column header Title that is big - I cannot increase the size of column. In Excel, how can I somehow fit the Title retaining the existing column width?

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

4) How can I prevent users from entering duplicate values in a range?

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

6) How can I enter a picture in a cell?

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

8) I have a big Table spanning across pages when printed - how do I get Excel to print titles in all pages?

9) I want to add a trend indicator symbol next to my sales data - how can I do that?

10) I am considering an investment of $500 per month for 3 years @ 6% interest rate. What is the Present Value of investment?

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

12) How can I filter a table to get all records that have less than a particular value in a specific column?

13) How to read a value from a cell in vba in Excel

14) Remove the apostrophe cell text values in Excel

15) I have read that Merging cells should be avoided if possible. In Excel, how can I then make my Title appear in the center of my Data Table?