how about

        .ChartTitle.Text = "Configuration " & Worksheets("Sheet1").Range("MyRange").Value & " DC Resistance"
hth