Okay, after days of searching and finding many many people with the exact same problem and no solution ever given, I have found the solution. Translating this VBA would not work, the code is completely different.

Solution:
$Chart->SeriesCollection(1)->LetProperty('XValues', $Range);

I found this solution in a post by ralife. Thank you for figuring this out for me with out even knowing.:)