text boxes pin and charts

[Mikexcel]

Hello All:

Is there any way possible to pin a text box to a chart, so that when you move the chart itself, the textboxes will follow. I need to have the textboxes on the chart because the info within them are a combination of dynamic and static.

 

[jfuoti]

Make sure you are in the chart. Go into the formula line (or hit F2) and start typing the text you want or just the adress for the cell you want to link and hit enter. This will create a text box within the chart that will move with it. The great thing is that it can be dynamic, so if you link it to a cell and change the cell, the text on the chart will be updated. HTH.

 

[Mikexcel]

thanks - it is always the 1st place that you shuold have looked, i guess.