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/
_______


D Moore wrote:

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