MarkerForegroundColor not working
Hi Todd,
The code looks OK but how would you see the Foreground when applying same
colour to Background
try testing with
..MarkerBackgroundColorIndex = xlNone
Regards,
Peter T
wrote in message
ups.com...
Hi, I'm using the following code to try and set the foreground and
background color of my markers, but I get nothing. When I add the line
in about changing marker size, that does work. Does anyone have any
suggestions as to what I may be doing wrong?
Sub TestMarkerColor()
With ActiveChart.SeriesCollection(1)
.MarkerForegroundColor = RGB(255, 0, 0)
.MarkerBackgroundColor = RGB(255, 0, 0)
'.MarkerSize = 5 + 10 * Rnd
End With
End Sub
I'm running Excel 2004 v11.3 on the Mac.
Thanks in advance,
Todd
|