Charting with OWC

[drkestrel]

Trying to use the Office Web Component 9.0 (that comes with Office XP) to draw a graph with just dots plotted and no lines, couldn't figure out how to get rid of the lines.

I even tried experimenting in Excel, using Tools->Record Macro to do what I want and then copy the code from VBA into VB Forms apps.

Here is the code from VBA as generated by Excel:

ActiveChart.SeriesCollection(1).Select
    With Selection.Border
        .Weight = xlThin
        .LineStyle = xlNone
    End With

But in VB Forms, it doesn't quite work.

Friend WithEvents chsDataPresentation As AxOWC10.AxChartSpace
'If objChartLineSelection is dimmed as a ChSeries, I could get to objChartLineSelection.Border, but there isn't a LineStyle.  
If I dim objChartLineSelection  as a Range, I could only get to objChartLineSelection.Borders

Dim objChartLineSelection As OWC10.ChSeries

chsDataPresentation.Charts.Item(0).Type = OWC10.ChartChartTypeEnum.chChartTypeLineMarkers

Any clues how that could be done?