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

[e18]

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]

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

[e18]

Thank you very much
Simple and fast...

BTW: Great webpage of yours!!!, now added to my Favorites of course