You don't need to escape the $ in a single quoted string.

    # This line here blows everything up.            
    $Chart1->SetSourceData({Source =>'=Data!\$A\$2:\$A\$295'}
[download]

However, that doesn't fix the problem. The syntax of the second example using the Excel range seems correct but doesn't work. I tried several variations with no success.

--
John.