Controlling Marker Attributes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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/
_______
 
Back
Top