I've been trying to use pictures as data markers in a line graph series. It is proving way harder than I expected.
The code I am using is:
.HasTitle = True
.ChartTitle.TEXT = "Pure Tone Bone Conduction Audiogram"
.SeriesCollection(1).border.LineStyle = xlLineStyleNone
.SeriesCollection(1).MarkerStyle = xlMarkerStylePicture
.SeriesCollection(1).Fill.UserPicture picturefile:=gstrApplicationPath & "\Pictures\Masked Right Bone Conduction.jpg"
'.SeriesCollection(1).MarkerBackgroundColorIndex = 0
'.SeriesCollection(1).MarkerForegroundColorIndex = 1
The line in red is where I am having the problems. It throws and error "Unable to set the marker style of the series class."
Is anyone able to help. I am using Access 2010.
I just want to use a [ as a data marker. Unfortunately it is the only symbol I can use for this particular graph.