All I want to do is to look at a chart where there is a single data point
selected and find out which point is selected - without there being anything
special about the series collection. I am not sure it is possible.

Bill




"Tom Ogilvy" wrote in message
...
What am I missing?

How to find out what point it is? <g

seriously, what do you want to know. Which point (index) it is in the
points collection of the Series. Not to say I can tell you that, but I
can
see if I can figure it out. (there doesn't appear to be anything inherent
to
a point object that will tell you that.) I could always change an
attribute
of the point, then loop through the points until I found the point with
that
unique attribute, then change it back.

--
Regards,
Tom Ogilvy

"Bill" wrote in message
...
Hello Tom,

You are correct (of course). But I still don't know what point it is,
just
that it is a point that is selected. What am I missing?

Bill


"Tom Ogilvy" wrote in message
...
In a line chart embedded in a worksheet, if I have a single point
selected:

? typename(selection)
Point
? typename(selection.parent)
Series


If I have a series selected
? typename(selection)
Series

This seems to contradict your premis

--
Regards,
Tom Ogilvy


"Bill" wrote in message
...
Thanks Tom. But that doesn't work because I don't know x and y. I
don't
want to have the macro in the workbook with the chart sheet, but
that
may
be
the only way to do it.

Bill
"Tom Ogilvy" wrote in message
...
Look at GetChartElement

--
Regards,
Tom Ogilvy

"Bill" wrote in message
...
Hello,
I would like to
select a single point on a chart, then select a button that will
call
the
following subroutine:

AddCommenttoPoint(ByVal ElementID As Long, ByVal Arg1 As Long,
ByVal
Arg2
As
Long)

The elementID is XlSeries, Arg1 is the first series collection.
The
problem
I have is Arg2. I want that to be the data point that is
selected
on
the
series. How do I determine which data point is selected on a
series
collection using code? The Selected property does not work with
the
series
collection.

Thanks a lot.

Bill