I am trying to use MS Graph to display data in a chart. Unfortunately I need to use specific markers on the series. They are only [ and ] symbols but the choice of series markers is very limited to say the least.
I have been trying to use Pictures as the marker style, but keep hitting problems.
I am trying to use the following code to put the picture in as a marker.
Set myChart = Me.AudiometryGraph.Object.Application.Chart
.HasTitle = True
.ChartTitle.TEXT = "Pure Tone Bone Conduction Audiogram"
.SeriesCollection(1).border.LineStyle = xlLineStyleNone
.SeriesCollection(1).MarkerStyle = xlMarkerStylePicture
Me.AudiometryGraph.SeriesCollection(1).Fill.UserPi cture picturefile:=gstrApplicationPath & "\Pictures\Masked Right Bone Conduction.jpg"
When I run the code it is the red line that gives me the following error. 'Unable to set the marker style property of the series class.'
Does anyone know how to get images to work as data markers for a series on a line graph?