Linking the chart title to a cell
You can create dynamic text within a chart by linking the text element to a worksheet cell.If your chart does not already have the title displayed you can use Add Chart Element > Chart Title to insert one.
![](tip001h.png)
To create the link select the chart title and using the formula bar enter the cell address of the cell you want to link to.
You can also enter the = sign and then use your mouse to select the cell and the address will automatically be entered.
![](tip001i.png)
Now when the contents of B1 changes the charts title will automatically update..
The above technic can be applied to other text elements within a chart.
- Primary horizontal axis title
- Primary vertical axis title
- Secondary horizontal axis title
- Secondary vertical axis title
- Datalabels
- Value axis Display Units label
- Depth axis title
![](tip001d.png)
To create the link select the chart title and using the formula bar enter the cell address of the cell you want to link to.
You can also enter the = sign and then use your mouse to select the cell and the address will automatically be entered.
![](tip001e.png)
Now when the contents of B1 changes the charts title will automatically update..
The above technic can be applied to other text elements within a chart.
- Primary horizontal axis title
- Primary vertical axis title
- Secondary horizontal axis title
- Secondary vertical axis title
- Datalabels
- Value axis Display Units label
- Depth axis title
![](tip001b.gif)
To create the link select the chart title and using the formula bar enter the cell address of the cell you want to link to.
You can also enter the = sign and then use your mouse to select the cell and the address will automatically be entered.
![](tip001c.gif)