Can anyone help me out here?
or
i tried .text and .value gives me a object required error.
Is there any ways i can put the series value into my string(s1)?
Code:
Dim s1 As String
s1 = ActiveChart.SeriesCollection(1).XValues.Text
Code:
Dim s1 As String
s1 = ActiveChart.SeriesCollection(1).XValues.Value
i tried .text and .value gives me a object required error.
Is there any ways i can put the series value into my string(s1)?