I would like to have a text box on my chart, whose text is generated by
concatenating the values from two different cells (B4 and B6) on a specific
worksheet in my Excel file. I was able to use a reference to cell B4 to
generate the text for my text box using the following formula:

='SSTyp-AllD'!$H$4

However, when I try to enter either of the following formulas for the text
box text:

=concatenate('SSTyp-AllD'!$H$4, 'SSTyp-AllD'!$H$6)
='SSTyp-AllD'!$H$4 & 'SSTyp-AllD'!$H$6

I get the error message "The text you entered is not a valid reference or
defined name".

Is what I am attempting to do simply impossible in Excel? (I am running
Excel 2003 SP1). Or, is there some way to do this that I am missing?

--
Thanks,
Mary S.

Hi,

The only formula you can use is a cell address. So do the concatenation
in another cell and link to that one instead.

Cheers
Andy

Mary S. wrote:
I would like to have a text box on my chart, whose text is generated by
concatenating the values from two different cells (B4 and B6) on a specific
worksheet in my Excel file. I was able to use a reference to cell B4 to
generate the text for my text box using the following formula:

='SSTyp-AllD'!$H$4

However, when I try to enter either of the following formulas for the text
box text:

=concatenate('SSTyp-AllD'!$H$4, 'SSTyp-AllD'!$H$6)
='SSTyp-AllD'!$H$4 & 'SSTyp-AllD'!$H$6

I get the error message "The text you entered is not a valid reference or
defined name".

Is what I am attempting to do simply impossible in Excel? (I am running
Excel 2003 SP1). Or, is there some way to do this that I am missing?


--

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