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
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