Marker Size and Marker Style

The MarkerSize property returns or sets the size of a data point in points (as a Long). The property also applies to the Series object, in which case it sets all markers in the series at once.

The MarkerStyle property determines the style of the data point and can be one of the following values:

Enum XlMarkerStyle xlMarkerStyleX = -4168 xlMarkerStylePicture = -4147 xlMarkerStyleNone = -4142 xlMarkerStyleDot = -4118 xlMarkerStyleDash = -4115 xlMarkerStyleAutomatic = -4105 xlMarkerStyleSquare = 1 xlMarkerStyleDiamond = 2 xlMarkerStyleTriangle = 3 xlMarkerStyleStar = 5 xlMarkerStyleCircle = 8 xlMarkerStylePlus = 9 End Enum

To illustrate, the following code produces the rather odd-looking chart in Figure 21-29.

With ActiveChart.SeriesCollection(1) .MarkerSize = 10

.MarkerStyle = xlMarkerStyleDiamond With .Points(2)

.MarkerSize = 20

.MarkerStyle = xlMarkerStyleCircle End With End With

Tea387 ly®

Figure 21-29. Illustrating MarkerSize and MarkerStyle

Figure 21-29. Illustrating MarkerSize and MarkerStyle

Marker Size Excel

Was this article helpful?

+4 -4
Black Jack Tactics Conquering The Game In Casinos

Black Jack Tactics Conquering The Game In Casinos

So, you want to learn how to play Blackjack. Youre in good hands. There is no better ship to chart those learning waters than the one youre riding on right now.

Get My Free Ebook


Responses

  • FELICITY CRAIG
    How to get value of marker size of data points using macro?
    8 years ago
  • florian gloeckner
    How to change size of data marker in excel chart legend?
    8 months ago
  • lalia
    How fill marker on chart with vba code?
    25 days ago

Post a comment