You might need to insert a dummy formula just to ensure there is a
recalculation when A1 is updated, something like =A1 in a cell someplace.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jon Peltier" wrote in message
...
That depends on how the data in A1 is provided. If it's a user-entered
value, you could use the Worksheet_Change event of the worksheet to note
the time of the change in the first blank cell in column B and the new
value of A1 in the adjacent cell in column C. If it's a DDE link, you
could use the Worksheet_Calculate event in the same way.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Alectrical" wrote in message
...
Thanks Jon

But how do I create the mechanism to store the data in columns B and C.


"Jon Peltier" wrote:

A chart needs data to plot. You would need some mechanism, probably
programmatic, to record values from A1 as well as times when A1 changes.
These two additional sets of values, stored perhaps in columns B and C,
would form the source data for the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Alectrical" wrote in message
...
Hi

I have a variable in cell A1, that I need to plot a histogram of. I
need
to
create two axis to create a real time chart, where axis one will be an
index
value of when the variable in cell A1 changes value, and axis two will
be
the
new variable value.

Any Ideas would be appreciated.

Thanks
Alec