Linked/dynamic Chart titles, text boxes etc...
 

Is it possible to link text in charts and text boxes to a range without
making a macro? If 'yes', then how can this be done?


--
e18
------------------------------------------------------------------------
e18's Profile: http://www.excelforum.com/member.php...fo&userid=7355
View this thread: http://www.excelforum.com/showthread...hreadid=523449

Linked/dynamic Chart titles, text boxes etc...
 

Hi,

Yes its possible, you can link title text to a single cell.
http://www.andypope.info/tips/tip001.htm

for data labels the technique is the same but try this addin to speed up
the process.
http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy

e18 wrote:
Is it possible to link text in charts and text boxes to a range without
making a macro? If 'yes', then how can this be done?



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Linked/dynamic Chart titles, text boxes etc...
 

Thank you very much
Simple and fast...
:)
BTW: Great webpage of yours!!!, now added to my Favorites of course


--
e18
------------------------------------------------------------------------
e18's Profile: http://www.excelforum.com/member.php...fo&userid=7355
View this thread: http://www.excelforum.com/showthread...hreadid=523449

Linked/dynamic Chart titles, text boxes etc...
 

Thank you very much
Simple and fast...
:)
BTW: Great webpage of yours!!!, now added to my Favorites of course


--
e18
------------------------------------------------------------------------
e18's Profile: http://www.excelforum.com/member.php...fo&userid=7355
View this thread: http://www.excelforum.com/showthread...hreadid=523449