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](images/faq_images/link-chart-title-and-cell-value-1.png)
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](images/faq_images/link-chart-title-and-cell-value-2.png)
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](images/faq_images/link-chart-title-and-cell-value-3.png)
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](images/faq_images/link-chart-title-and-cell-value-4.png)
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)?