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