No line, only marker in linegraph

[boerbende]

Dear fellow developers,

I can change multiple things on a line graph with VBA.
Me.Graph47.chartType = GraphType ' take 65 for line
with me.graph47
.SeriesCollection(1).border.Color = vbblue ' change the line color
.SeriesCollection(1).border.Weight = LineWeight ' change the line weight to for example 3
.SeriesCollection(2).MarkerSize = MarkerWeight ' Change the marker weight, for example 4
.SeriesCollection(2).MarkerBackgroundColor = vbblue ' Change the marker color,
.SeriesCollection(2).axisgroup = 2 ' put this series on the secondary axis

end with

SeriesColection(1) is line with markers. This is correct
But now I want the seriescollection(2) without line, so only the markers. I cheched the MSDN site from Microsoft. The Excel trick with the macro does not work for me.

Anybody knows how to hide the line with VBA for only SeriesCollection(2) in Access?

Many thanks

Ben

 

[boerbende]

I have used a workaround
.SERIESCOLLECTION(2).border.Color = vbwhite ' make the linecolor similar to the background which is white