Format Line Chart with VBA

[tourgis2000]

Hi,

I've looked everywhere and I cannot find a way of getting rid of the line colour in a 2007 chart, not to mention getting the right colour green of the marker, the black outline or the shadow. The macro recorder does not show the steps at all! this is what I am trying to get to:

And here is the relevant code:

With ActiveChart.SeriesCollection.NewSeries
        .ChartType = xlLineMarkers
        .Name = "GRPs"
        .Values = "GRPs!ChtGRPsStationValues2"
        .AxisGroup = 2
        .MarkerStyle = xlMarkerStyleCircle
        .MarkerBackgroundColorIndex = 10 'not the right colour,
        'also needs the black outline and the shadow
        .MarkerSize = 10
        .LineStyle = xlLineStyleNone 'doesn't work at all
End With

Can anyone help?

Thanks,

Martin