Monday, 02 March 2020
  0 Replies
  2.9K Visits
0
Votes
Undo
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
There are no replies made for this post yet.