Hi Group,

Using Excel 2003, in excel chart, I have changed the chart title to generate
the name based on a cell text. But, all I want is to append text to the
generated name.

My sample formula for chart name looks like
='MySheet'!$B$1.
But if I change to
='MySheet'!$B$1 & "Hello Text" and also,
='MySheet'!$B$1 & TEXT("Hello Text")
does not seem to work.


I am happy to find forum that will ease my job.

Best Regards