changing cells

hi, i have a question regarding something i'm trying to
chart.

i have seven cells, all OLE linked to a program. thus,
these cells change constantly.

here's an example of what i'm trying to accomplish. let's
say cells A1:A3 have the links.

for ease, how do i make a chart graphing the value of cell
A2 vs. value in A3? I want the data points to chart
everytime the value in A1 changes (when A1 changes, all
other cells change as well). Thus, the graph will keep
growing, and add new data points accordingly.

sorry for the long post.

Peter -

It's tricky to keep older values from linked cells like this. You could
write a program to store the values elsewhere in the worksheet, but the
events that tell the macro when to run are not reputed to be reliable.

There's another approach using circular references, described by Stephen
Bullen: http://bmsltd.co.uk/DLCount/DLCount...le=Previous.zip

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

peter wrote:
> hi, i have a question regarding something i'm trying to
> chart.
>
> i have seven cells, all OLE linked to a program. thus,
> these cells change constantly.
>
> here's an example of what i'm trying to accomplish. let's
> say cells A1:A3 have the links.
>
> for ease, how do i make a chart graphing the value of cell
> A2 vs. value in A3? I want the data points to chart
> everytime the value in A1 changes (when A1 changes, all
> other cells change as well). Thus, the graph will keep
> growing, and add new data points accordingly.
>
> sorry for the long post.