Concatenating Text and Date in a chart series Name box.

[Richard Buttrey]

Hi,

In the Name box of a data series in a chart, the name appears as
="Some Name"

I'd like to concatenate on to it, the contents of a named range
(actually a date)

So in the range "MyDate" I have a date number formatted as a date -
say 24/08/06 and I'd like the Legend on the chart for the series in
question to show

Some Name 24/08/06

I've tried the putting in the Name box the obvious ="Some Name" &
range("MyDate") but XL doesn't seem to like this.

Any suggestions?

Usual TIA
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

 

[Guest]

Hi Richard,
Try ="Some Name" & TEXT(MyDate,"dd,mm,yy")
Regards,
Stefi


„Richard Buttrey†ezt írta:

 

[Richard Buttrey]

Hi Stefi,

Unless I'm doing something stupid, - not entirely unknown, that
doesn't seem to work. Any ideas???

Rgds

Hi Richard,
Try ="Some Name" & TEXT(MyDate,"dd,mm,yy")
Regards,
Stefi


„Richard Buttrey” ezt írta:

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

 

[Guest]

Sorry Richard, perhaps because I used wrong date separator, try this one:

="Some Name" & TEXT(MyDate,"dd/mm/yy")


Stefi

„Richard Buttrey†ezt írta:

 

[Richard Buttrey]

Thanks Stefi,

For some reason this doesn't work when it's entered directly in the
name box of the chart data series, but it works if I hold it in a cell
in the worksheet and refer to that cell from the name box.

Odd, but at least it works. Any idea why it wouldn't work when entered
directly?

Rgds

Sorry Richard, perhaps because I used wrong date separator, try this one:

="Some Name" & TEXT(MyDate,"dd/mm/yy")


Stefi

„Richard Buttrey” ezt írta:

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

 

[Guest]

Sorry Richard, I don't know the reason, but I've an idea for you to try:

=CONCATENATE("Some name ",TEXT(MyDate,"dd/mm/yy"))

Regards,
Stefi

„Richard Buttrey†ezt írta:

 

[Richard Buttrey]

Thanks Stefi,

Unfortunately the chart name box doesn't seem to like the concatenate
function either, and comes up with the error message "'That function
is not valid".

Not to worry, I'll put it down to one of Excel's little quirks. The
indirect method seems to be working OK. Thanks for your input
nevertheless.

Regards

Sorry Richard, I don't know the reason, but I've an idea for you to try:

=CONCATENATE("Some name ",TEXT(MyDate,"dd/mm/yy"))

Regards,
Stefi

„Richard Buttrey” ezt írta:

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________