Re: Series Collection Points
From: Bill (whmc2_at_ix.netcom.com)
Date: 09/27/04
- Next message: scottwilsonx: "Calculating and copying data into new sheet"
- Previous message: Mike D.: "Macro to list files"
- In reply to: Tom Ogilvy: "Re: Series Collection Points"
- Next in thread: Tom Ogilvy: "Re: Series Collection Points"
- Reply: Tom Ogilvy: "Re: Series Collection Points"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 27 Sep 2004 12:07:47 -0500
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" <twogilvy@msn.com> wrote in message
news:urDoX9KpEHA.2536@TK2MSFTNGP10.phx.gbl...
> > 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" <whmc2@ix.netcom.com> wrote in message
> news:O8NcEtKpEHA.3624@TK2MSFTNGP10.phx.gbl...
> > 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" <twogilvy@msn.com> wrote in message
> > news:eM9GzfKpEHA.3668@TK2MSFTNGP15.phx.gbl...
> > > 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" <whmc2@ix.netcom.com> wrote in message
> > > news:Oi4GiVKpEHA.3688@TK2MSFTNGP09.phx.gbl...
> > > > 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" <twogilvy@msn.com> wrote in message
> > > > news:%23NsZk3JpEHA.3860@TK2MSFTNGP10.phx.gbl...
> > > > > Look at GetChartElement
> > > > >
> > > > > --
> > > > > Regards,
> > > > > Tom Ogilvy
> > > > >
> > > > > "Bill" <whmc2@ix.netcom.com> wrote in message
> > > > > news:OQCj6iJpEHA.596@TK2MSFTNGP11.phx.gbl...
> > > > > > 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
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
- Next message: scottwilsonx: "Calculating and copying data into new sheet"
- Previous message: Mike D.: "Macro to list files"
- In reply to: Tom Ogilvy: "Re: Series Collection Points"
- Next in thread: Tom Ogilvy: "Re: Series Collection Points"
- Reply: Tom Ogilvy: "Re: Series Collection Points"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
