VBA code for format fill and border line color for Scatter Chart in Excel 2013

Hi i am using the excel 2013



VBA code for format fill and borderline color for Scatter Chart in Excel 2013



I tried the recording macro the “Clustered Bar Chart” and “Scatter Chart”. but I cannot make the recording macro the format fill and border line color



I expect below the chart



1. For series "target" - the Marker Fill color is Red and the same border color, line color is no.

2. For series "actul" - the Marker Fill color is Black and the same border color, line color is no.



Kindly provide the VBA code and Thanks for Advance