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