Put the times in one column and the rates in the next, then create an XY
chart. I can't tell a lot from your post, but if you expect Excel to
determine a rate from the time, it will not. You have to write some formulas
to calculate them (in the second column mentioned above). Is the system time
some kind of limit? Do you need to add a vertical or horizontal line to the
chart?

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


"vijaicbe" wrote in message
...
i want to create a line chart in excel for rate vs time as y & x axis data.
the chart
should be an automatic charting as, when the particular time
(10,10.30,11,11.30 ...)of system time reaches the data in one cell (rate )
should be taken automatically for charting the chart for 10am to 11.30pm.
the
only thing is how to check logically
if the system time reached or not.