How to change the line color on radar chart

[JWS315]

How can I change the line color of a series in a radar chart? The chart is
built using MS Graph and I am using the following code to change the marker
style but can not find how to change the line. Any help would be greatly
appreciated!

Set oShape = docFinal.InlineShapes.AddOLEObject(ClassType:="MSGraph.Chart",
DisplayAsIcon:=False, Range:=myRange)
Set oChart = oShape.OLEFormat.Object

code to load values...

With oChart.SeriesCollection(1)
.HasDataLabels = False
.HasLeaderLines = False
.MarkerSize = 10
.MarkerBackgroundColor = RGB(255, 0, 0) ' red
.MarkerForegroundColor = RGB(255, 0, 0) ' red
End With

 

[Kate G.]

What version of Word? Maybe I'm not understanding what you want... but
can't you just right click with the cursor over the line... (while "IN" the
graph) and select FORMAT GRIDLINES ... and change the color?

(This works in 2000 & 2003) -- and it is so easy ... so maybe I'm not
"getting it".

 

[JWS315]

Kathryn,

I need to make the change via vba code since the chart is being generated
through automation from Access. I found the property for the marker but
can't seem to find the associated line property. Should I post this question
in the programming forum versus this forum?

Thanks

Jerry