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
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". -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Kathryn Groves "JWS315" wrote in message news:A0B145B7-E6BC-47BB-A00B-64B4F1064769@microsoft.com... > 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
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 "Kate G." wrote: > 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". > > > > -- > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Kathryn Groves > > > "JWS315" wrote in message > news:A0B145B7-E6BC-47BB-A00B-64B4F1064769@microsoft.com... > > 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 > > >
