Tuesday, February 28, 2012

Excel Chart - Line Chart Marker Styles

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

No comments: