Controlling Marker Attributes

[D Moore]

Is there a way to control the attributes (point size
style, color, etc.) of a marker for a scatter chart b
setting them programmatically (via Visual Basic o
other means) or by setting the values in cells

Thanks in advance.

 

[Jon Peltier]

VBA is suited to this tedious task. Turn on the macro recorder while you
format some markers, and then examine the code. You can put desired
values into the worksheet, and have the procedure get the parameters
from there. A relevant snippet of code looks like this:

With ActiveChart.SeriesCollection(1).Points(2)
.MarkerBackgroundColorIndex = 15 ' gray
.MarkerForegroundColorIndex = 1 ' black
.MarkerStyle = xlSquare
.MarkerSize = 7
End With

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______