How do you set all graph data points to black (multiple series)?

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

Guest

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