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

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

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

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

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

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