How can Macro find first XValue in on XYScatter chart?

[hill0093]

In Excel 2003 on a particular set of data I copy
(select and control C) "=fileTable!$D$5660:$D$8496" from
Chart > Source Dara > Series > Series1 > Xvalues
but "Record New Macro" won't tell me how to get it by Macro.
I need the first XValue of Series1 in an XYScatter Chart in
a Macro I'm writing. How can my Macro get it? The Macro is
one that shows under "View Code" of the Chart.

 

[hill0093]

Sorry, the Thread Title is a little messed up.
I thought that maybe there might be a code statement like

dblNum = ActiveChart.SeriesCollection(1).Points(1).XValue

that would retrieve either the first XValue of the series or
the first XValue on the Chart. But maybe VBA doesn't allow
such a retrieval.

 

[John_w]

    Dim xv As Variant
    xv = ActiveChart.SeriesCollection(1).XValues
    Debug.Print xv(1)

 

[hill0093]

Thank you so much.
I haven't tried it yet, but it feels right.