Dear Jon, Tnx for the reply
See i want to draw a price track chart for a product, which onec price
changes minute by minute. for example take gold
by 10am it is costing Rs.9100 (Indian rupee)
by 10.15am it is 9000
by 10.30am it is 9400
by 10.45am it is 8900
..
..
..
..
by 11.30pm it is 9200
Now i want to draw chart where time in x axis and price in y axis
i'll be getting the price value in one cell after some calculation (for
example @ A13). now i can do the chart by posting the price to predefined
value for x axis, but what i want is, when the system time is 10.am or
10.30am or ...., excel should plot the chart automatically by taking the
value from the cell A13. for this i need to check the following
IF SYSTEM TIME = Z (WHERE Z IS 10.00AM ,10.30AM, ... 11.30PM)
CHECK THE VALUE @ CELL A13 AND PLOT THE POINT IN CHART
AS X AXIS VALUE =Z AND Y AXIS VALUE FROM CELL A13
OR
I WANT TO MOVE THE VALUE FROM CELL A13 TO D1,D2,D3...... AUTOMATICALLY WHEN
THE SYSTEM TIME IS 10.10.30......,WHERE
Cxx & Dxx ARE THE VALUES OF X AXIS AND Y AXIS OF MY CHART
| C D
----|--------------------------------------------------
1 | 10.00 9000
2 | 10.30
3 | 11.00
4 | 11.30
5 | 12.00
6 | 12.30
7 | 01.00
8 | 01.30
9 | 02.00
10 | 02.30
..
..
..
..
..
28 | 11.30 9200
-----------------------------------
HOPE NOW YOU MIGHT HAVE A CLEAR IDEA PL HELP ME
THANK YOU
------------------------------------------------------------