VBA to reference Chart Sheet

Hello,

I'm missing something that might be very obvious to someone else, but can't figure out a solution.

I'm trying to reference a chart, that is on its own Chart Sheet ("Chart Sheet 1") and edit the data series range.

I've tried lots of combinations, but could someone please correct my attempt below?

Please Login or Register  to view this content.

I'm trying to avoid selecting each chart (as there are multiple cahrts in my workbooks, all on seperate chart sheets.

Any help would be greatly appreciated.

Rob