Insert String Between Dates in Chart Title
I expect that you can only link directly to a cell, not using any function
within that link
--
Regards,
Peo Sjoblom
"RyanH" wrote in message
...
I tried this already in another cell and it works fine:
=TEXT(Summary!$A$2,"mm/dd/yyyy")&" to "&TEXT(Summary!$B$2,"mm/dd/yyyy")
Any ideas on why you can't put this in the formula bar for the chart
title?
--
Cheers,
Ryan
"Peo Sjoblom" wrote:
One way would be to put this formula in a cell, assume you put it in K3
(or hide it away in IV2 or something)
=TEXT(Summary!$A$2,"mm/dd/yyyy")&" to "&TEXT(Summary!$B$2,"mm/dd/yyyy")
(adapt to fit the regional date format you are using)
then click in the title of the chart and type an equal sign and click on
K3
so the title when selected would read
=Summary!$K$3
that way it would be dynamic and display as
10/12/2008 to 10/28/2008
as an example
--
Regards,
Peo Sjoblom
"RyanH" wrote in message
...
I have a chart that displays data between two dates. I want the title
to
read like this:
Range("A2").Value & " to " & Range("B2").Value
I highlighted the title box and entered this in the formula bar and
Excel
will not accept it, why?
=Summary!$A$2&" to "&Summary!$B$2
--
Cheers,
Ryan
|