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: www.excelforum.com/member.php...foamp;userid=7355
View this thread: www.excelforum.com/showthread...hreadid=523449Hi,
Yes its possible, you can link title text to a single cell.
www.andypope.info/tips/tip001.htm
for data labels the technique is the same but try this addin to speed up
the process.
www.appspro.com/Utilities/ChartLabeler.htm
Cheers
Andy
e18 wrote:
gt; Is it possible to link text in charts and text boxes to a range without
gt; making a macro? If 'yes', then how can this be done?
gt;
gt;
--
Andy Pope, Microsoft MVP - Excel
www.andypope.info
Thank you very much
Simple and fast...
BTW: Great webpage of yours!!!, now added to my Favorites of course--
e18
------------------------------------------------------------------------
e18's Profile: www.excelforum.com/member.php...foamp;userid=7355
View this thread: www.excelforum.com/showthread...hreadid=523449
Thank you very much
Simple and fast...
BTW: Great webpage of yours!!!, now added to my Favorites of course--
e18
------------------------------------------------------------------------
e18's Profile: www.excelforum.com/member.php...foamp;userid=7355
View this thread: www.excelforum.com/showthread...hreadid=523449
- Apr 21 Sat 2007 20:37
Linked/dynamic Chart titles, text boxes etc...
close
全站熱搜
留言列表
發表留言