Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you set all graph data points to black (multiple series)?
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GRAPH data labels | Excel Discussion (Misc queries) | |||
New data in table not showing in graph | Excel Discussion (Misc queries) | |||
How can I get 7.3 million data pts on one line graph? | Excel Discussion (Misc queries) | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |