Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Monday, 02 March 2020
  0 Replies
  2.8K 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.