Re: Selecting Data Points from graph

From: Keith Bramley (keith.bramley_at_nospamthankupleasebaesystems.com)
Date: 03/03/05 

Date: Thu, 3 Mar 2005 16:17:39 -0000

Thank you for your response, i will give it a go tomorrow morning along with
a strong cup of coffee

regards

Keith

"Bernie Deitrick" <deitbe @ consumer dot org> wrote in message
news:#PQMTBAIFHA.3428@TK2MSFTNGP10.phx.gbl...
> Keith,
>
> There still isn't an easy VBA method to tell what graph point is
selected -
> This has been a desired addition to Excel for a long time.
>
> But, there is a fairly simple workaround. Make a copy of your data, and
> paste it nearby. Graph the data, and when you select your data points,
> click each and then wait until the cursor turns into a double headed
arrow,
> and then click and drag the data point. Doing so will actually change the
> data in the data table used to generate the graph.
>
> Then, when you are done doing so, create another table of formulas, using
a
> formula like:
>
> =IF(A1<>G1,G1,"")
>
> Where A1 is the upper left hand cell of your graphed data, and G1 is the
> upper left hand cell of the copy of the data set. Copy the formula to
> create another table, and only the original values of the points that you
> changed will appear within the formula table. Of course, you may need to
> modify the formula to pick up other values like labels and headers, but
that
> should give you the general idea.
>
> HTH,
> Bernie
> MS Excel MVP
>
> "Keith Bramley" <keith.bramley@nospamthankupleasebaesystems.com> wrote in
> message news:4226ea65$1_1@baen1673807.greenlnk.net...
> > Hi,
> >
> > I have an Excel graph that i want to select points from, i have to
select
> > 100 or so
> > points from a set of about 1000, what i would like to do is scroll the
> > pointer along the graph and when i hit a point i would like to keep i
want
> > to be able to press enter or something and have that points data put
into
> a
> > new table/column on the spread***.
> >
> > Is it possible to do this with some form of macro or VB code
> >
> > thanks in advance
> >
> > Keith
> >
> >
> >
>
>