Notifications
Clear all
VBA & Macros
4
Posts
2
Users
0
Reactions
75
Views
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
Hi,
See the attached workbook. There's a new Sub called FormatSeries.
Regards
Phil
Posted : 03/03/2020 8:31 pm
Topic starter
Tnq so much.... It works perfectly and thanks for the new code.......
Posted : 04/03/2020 12:38 am
No worries.
Posted : 04/03/2020 2:52 am