Copy Paste text box from one chart to another

[Chuck101]

Hello - I have 10+/- charts and I use text boxes to display the same information on each chart e.g. Name, Department, Update date, Size, Color etc.. Each text box is linked back to a cell on a "user input" sheet. Depending on what I want to display I might need to add a text box to all of the charts. In Excel 03 I could create a text box on one chart then copy / paste from one chart to another and it would keep the cell referece. In Excel 07 copy / paste seems to be a copy / paste-special-values - it does not keep the cell reference. Is there an options setting I'm missing? Copy / paste works fine on normal sheets - the issue only seems to be with charts.

[Andy Pope]

Looks like a bug.
Although copying the chart with a linked textbox appears to keep the link.

You could use code to re-apply the link

[Chuck101]

I think you're right, must be a bug. Let Bill know next time you see him.

Thanks