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
__________________________
Hi Richard,
Try ="Some Name" & TEXT(MyDate,"dd,mm,yy")
Regards,
Stefi
„Richard Buttrey” ezt *rta:
> 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
> __________________________
>
Hi Stefi,
Unless I'm doing something stupid, - not entirely unknown, that
doesn't seem to work. Any ideas???
Rgds
On Mon, 24 Jul 2006 04:58:02 -0700, Stefi
<Stefi@discussions.microsoft.com> wrote:
>Hi Richard,
>Try ="Some Name" & TEXT(MyDate,"dd,mm,yy")
>Regards,
>Stefi
>
>
>Richard Buttrey ezt rta:
>
>> 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
>> __________________________
>>
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
Sorry Richard, perhaps because I used wrong date separator, try this one:
="Some Name" & TEXT(MyDate,"dd/mm/yy")
Stefi
„Richard Buttrey” ezt *rta:
> Hi Stefi,
>
> Unless I'm doing something stupid, - not entirely unknown, that
> doesn't seem to work. Any ideas???
>
> Rgds
>
>
> On Mon, 24 Jul 2006 04:58:02 -0700, Stefi
> <Stefi@discussions.microsoft.com> wrote:
>
> >Hi Richard,
> >Try ="Some Name" & TEXT(MyDate,"dd,mm,yy")
> >Regards,
> >Stefi
> >
> >
> >„Richard Buttrey” ezt *rta:
> >
> >> 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
> >> __________________________
> >>
>
> __
> Richard Buttrey
> Grappenhall, Cheshire, UK
> __________________________
>
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
On Mon, 24 Jul 2006 23:51:02 -0700, Stefi
<Stefi@discussions.microsoft.com> wrote:
>Sorry Richard, perhaps because I used wrong date separator, try this one:
>
>="Some Name" & TEXT(MyDate,"dd/mm/yy")
>
>
>Stefi
>
>Richard Buttrey ezt rta:
>
>> Hi Stefi,
>>
>> Unless I'm doing something stupid, - not entirely unknown, that
>> doesn't seem to work. Any ideas???
>>
>> Rgds
>>
>>
>> On Mon, 24 Jul 2006 04:58:02 -0700, Stefi
>> <Stefi@discussions.microsoft.com> wrote:
>>
>> >Hi Richard,
>> >Try ="Some Name" & TEXT(MyDate,"dd,mm,yy")
>> >Regards,
>> >Stefi
>> >
>> >
>> >Richard Buttrey ezt rta:
>> >
>> >> 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
>> >> __________________________
>> >>
>>
>> __
>> Richard Buttrey
>> Grappenhall, Cheshire, UK
>> __________________________
>>
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
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:
> 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
>
>
>
> On Mon, 24 Jul 2006 23:51:02 -0700, Stefi
> <Stefi@discussions.microsoft.com> wrote:
>
> >Sorry Richard, perhaps because I used wrong date separator, try this one:
> >
> >="Some Name" & TEXT(MyDate,"dd/mm/yy")
> >
> >
> >Stefi
> >
> >„Richard Buttrey” ezt *rta:
> >
> >> Hi Stefi,
> >>
> >> Unless I'm doing something stupid, - not entirely unknown, that
> >> doesn't seem to work. Any ideas???
> >>
> >> Rgds
> >>
> >>
> >> On Mon, 24 Jul 2006 04:58:02 -0700, Stefi
> >> <Stefi@discussions.microsoft.com> wrote:
> >>
> >> >Hi Richard,
> >> >Try ="Some Name" & TEXT(MyDate,"dd,mm,yy")
> >> >Regards,
> >> >Stefi
> >> >
> >> >
> >> >„Richard Buttrey” ezt *rta:
> >> >
> >> >> 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
> >> >> __________________________
> >> >>
> >>
> >> __
> >> Richard Buttrey
> >> Grappenhall, Cheshire, UK
> >> __________________________
> >>
>
> __
> Richard Buttrey
> Grappenhall, Cheshire, UK
> __________________________
>
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
On Thu, 27 Jul 2006 00:03:02 -0700, Stefi
<Stefi@discussions.microsoft.com> wrote:
>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:
>
>> 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
>>
>>
>>
>> On Mon, 24 Jul 2006 23:51:02 -0700, Stefi
>> <Stefi@discussions.microsoft.com> wrote:
>>
>> >Sorry Richard, perhaps because I used wrong date separator, try this one:
>> >
>> >="Some Name" & TEXT(MyDate,"dd/mm/yy")
>> >
>> >
>> >Stefi
>> >
>> >Richard Buttrey ezt rta:
>> >
>> >> Hi Stefi,
>> >>
>> >> Unless I'm doing something stupid, - not entirely unknown, that
>> >> doesn't seem to work. Any ideas???
>> >>
>> >> Rgds
>> >>
>> >>
>> >> On Mon, 24 Jul 2006 04:58:02 -0700, Stefi
>> >> <Stefi@discussions.microsoft.com> wrote:
>> >>
>> >> >Hi Richard,
>> >> >Try ="Some Name" & TEXT(MyDate,"dd,mm,yy")
>> >> >Regards,
>> >> >Stefi
>> >> >
>> >> >
>> >> >Richard Buttrey ezt rta:
>> >> >
>> >> >> 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
>> >> >> __________________________
>> >> >>
>> >>
>> >> __
>> >> Richard Buttrey
>> >> Grappenhall, Cheshire, UK
>> >> __________________________
>> >>
>>
>> __
>> Richard Buttrey
>> Grappenhall, Cheshire, UK
>> __________________________
>>
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks