Edit Series text in Charts

Hi, I'm trying to edit all data fields in a Chart page to remove al references to linked workbooks, I've done it successfully for worksheets but the Charts is throwing an error (doesn't support this object) at the line with

Please Login or Register  to view this content.

When I created a macro it returned this

Please Login or Register  to view this content.

so I used that as my guide for coding.

My code for the full procedure is below, if anyone can offer some insight I'd very much appreciate it.

Please Login or Register  to view this content.