Dynamic textbox in chart ?

[TRT]

Dear All,
Is it possible to create a "dynamic" textbox within a chart (a textbox with reference to a cell outside the chart) ?

Kind regards
Torben

[Glenn Kennedy]

Yes. Create the textbox. With it selected, click in the formula bar and enter the full cell reference like this

=Sheet1!$D$1 or (if the sheet name contains spaces):

='A different sheet'!$D$1

[TRT]

Yes. Create the textbox. With it selected, click in the formula bar and enter the full cell reference like this

=Sheet1!$D$1 or (if the sheet name contains spaces):

='A different sheet'!$D$1

Thanks a lot - (That simple... almost embarrassed to have asked the question..:-) )

[Glenn Kennedy]

No problem! It's only simple if you know the answer....

[TRT]

..let's say I want text from multiple cells connected to the textbox ... I tried with a ";" separator but that didn't work. How do I do that ?

[Glenn Kennedy]

I think (happy to be corrected) that you would need to combine the cells on the sheet itself and then refer to the combined label in the text box. I normally hide such cells behind the chart....

[TRT]

OK - got it. Have a nice day :-)

[Glenn Kennedy]

Just been googling. It can be done, but you need VBA.