Sometimes clients want various settings for their line charts.
The markers on their line charts can be circles, squares, crosses etc
Today we'll just focus on the four main styles
The VBA code is ActiveChart.SeriesCollection(1).MarkerStyle = 1
And you would loop through each series collection.
So the critical numbers are:
None --> 0
Square --> 1
Diamond --> 2
Triangle --> 3
Circle --> 8
Tuesday, February 28, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment