"Jon Peltier" wrote in message
...
Peter - One's the outline and one's the fill for markers like a square or
circle.

I appreciate that but it seemed to me that if the OP is applying same colour
to Background fill he won't see the Foreground outline. Thought perhaps if
applied no colour or a different colour to the background the foreground
change would be more obvious. Alternatively pehaps apply MarkerStyle xlDot
or xlDash which don't show background fill.

Regards,
Peter T

Todd - Keep in mind that Excel will only apply the colorindex of the color
in the palette that's closest to the RGB you enter. Granted, red is one of
the default colors, but try .MarkerForegoundColorIndex as well.

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


"Peter T" <peter_t@discussions wrote in message
...
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