Forum

VBA code for format...
 
Notifications
Clear all

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

4 Posts
2 Users
0 Reactions
75 Views
(@kpmsivaprakasam2003)
Posts: 15
Eminent Member
Topic starter
 

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

 
Posted : 03/03/2020 5:17 am
Philip Treacy
(@philipt)
Posts: 1630
Member Admin
 

Hi,

See the attached workbook.  There's a new Sub called FormatSeries.

Regards

Phil

 
Posted : 03/03/2020 8:31 pm
(@kpmsivaprakasam2003)
Posts: 15
Eminent Member
Topic starter
 

Tnq so much.... It works perfectly and thanks for the new code.......

 
Posted : 04/03/2020 12:38 am
Philip Treacy
(@philipt)
Posts: 1630
Member Admin
 

No worries.

 
Posted : 04/03/2020 2:52 am
Share: