Use VBA to change series legend labels in Datasheet

[SamuelDz]

Helllo all,

Im trying to modify the series labels of a chart (in the datasheet) in access using VBA, I have successfully used it to modify the data in the range but i now want to change the labels.

Is this possible?
below is the code im using to modify the data.

Private Sub Command318_Click()
Dim Graph_Data As Object
Dim objDataSheet As Object

Set Graph_Data = Me!UnboundChart.Object
Set objDataSheet = Graph_Data.Application.DataSheet

objDataSheet.Range("A1").Value = 9


Image below shows what I want change with vba

 

[isladogs]

Hi
For info, I moved this to the Excel forum.
Someone will I'm sure be along soon to assist

 

[SamuelDz]

Hi Sorry this is Access related.

 

[arnelgp]

objDataSheet.Range("01") ="my Label 1"
objDataSheet.Range("02") ="my Label 2"

 

[SamuelDz]

Thanks worked perfectly (Y)