Andy,

Thank you for your info. It's working now!

"Andy Pope" wrote:

Hi,

AAA methods works in all versions since xl97 and possible before but I
can not check.
He is another explanation.
http://www.andypope.info/tips/tip001.htm

Cheers
Andy

femke wrote:
For the "Name of a Serie", it's working correctly, referring to "=Sheet1!A1".
But for "Chart-title", "Value X" and "Value Y", your reference to
"=Sheet1!A1" is not working. Chart-title will be then "=Sheet1!A1".

I hope a newer version of Excel will work in the way you describe.

Thanks in advance.


"AAA" wrote:


It is eay to make an example to do this. You just nee to select the chart
title and then input an formula such as "=Sheet1!A1" in the formulabar.




--

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