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.

Yeah, I thought of that as well, but I figured the added size of the marker
from the outline would be noticeable. So we interpreted it differently.

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


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