Hello - I'm trying to turn on data labels that only show the series
names--not the data values, in a MS Graph (default line graph). I'm
getting a compile error "Named argument not found" on this VB
statement - "ShowSeriesName:=True"
I've tried different combinations of the code...
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim objChart As Graph.Chart
Set objChart = Graph0.Object
With objChart
.ApplyDataLabels Type:=xlDataLabelsShowLabel, LegendKey:=False,
AutoText:=True, ShowSeriesName:=True, ShowCategoryName:=False,
ShowValue:=False
.DataLabel.Font.Size = 9
.DataLabel.Position = xlLabelPositionAbove
End With
....and have searched the web, but have not come across any solution to
this. My version of Access is XP, and it has the Microsoft Graph 10.0
Object Library in the references.
Is it the Line Graph? Is it the 10.0 Object Library? the code?
Has anyone simply wanted series names as data labels in MS Graph in
Access and accomplished this? If so, I would love to hear from you.
Thanks a bunch!