On 14 Aug, 09:13, Chrisso wrote:
Hi

I am using a standard clustered column chart in Excel 2003.

I would like to be able to walk over all the points in a series and
extract the X value for inspection.

Is this possible? I cannot see how to do this.

Thanks in advance,
Chrisso

I should have stated that I have the code to walk over the points - I
just cannot see how to extract the X value for each point:

Dim cht As Chart, ser As Series
Set cht = ActiveChart
Set ser = cht.SeriesCollection(1)
Dim pt As Point
For Each pt In ser.Points
' ## how do I get the X value for pt?
Next pt

Cheers
Chrisso