I apologize for the confusion. I am not writing VBA code. I tried entering
what you have and I get an Exclamation MsgBox saying "References in series
formulas must be external references to worksheet."

A few more details. The chart is embedded in a worksheet, it is not its own
worksheet. When I select the title of the chart and then enter =Summary!$A$2
Excel accepts that and the title show the date in A2. but when I enter
=Summary!$A$2&" to "&Summary!$B$2 Excel doesn't except it.
--
Cheers,
Ryan


"klswvu" wrote:

If you are entering this in the Excel formula bar, try:

=A2&" to"&B2

The syntax looks like you are using VBA code outside of a macro.



"RyanH" wrote:

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