View Single Post
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

You can't do it using the native Excel interface, but a little macro
will handle it:

Sub PaintItBlack()
Dim srs As Series
For Each srs In ActiveChart.SeriesCollection
srs.Border.ColorIndex = 1
srs.MarkerBackgroundColorIndex = 1
srs.MarkerForegroundColorIndex = 1
Next
End Sub

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

DamnKiwi wrote:
I have multiple series on a chart, all with different marker shapes as
desired. How do I globally set all the data point colors to black without
picking each series in turn and setting a custom color.