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

  • kpmsivaprakasam2003
  • kpmsivaprakasam2003's Avatar Topic Author
  • Offline
More
5 months 1 week ago #2092 by kpmsivaprakasam2003
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

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun