Combine Formula and static Text
 

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

It is not possible to concatenate a chart title referring to a cell and a
text string,
you can use a macro that will do it or referring to a second cell where you
use the contents of one cell
(B1) and the string

--
Regards,

Peo Sjoblom

(No private emails please)


"Beginer" wrote in message
...
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

Hi Sjoblom,

Could you please provide me a sample work around ?

Thanks in advance,
Beginer

"Peo Sjoblom" wrote:

It is not possible to concatenate a chart title referring to a cell and a
text string,
you can use a macro that will do it or referring to a second cell where you
use the contents of one cell
(B1) and the string

--
Regards,

Peo Sjoblom

(No private emails please)


"Beginer" wrote in message
...
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