Insert String Between Dates in Chart Title
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
|