Re: Selecting Data Points from graph

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Bernie Deitrick (_at_)
Date: 03/03/05 

Date: Thu, 3 Mar 2005 09:50:19 -0500

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
>
>
>

Quantcast