Hi Pate,

Try these steps.

Change the x axis values to the formula =NOW(), so that it will call the
current system date&time and it will appear in the Graph. If you would like
to have only the Time to appear you select the Format (Menu) - Cells -
Number (TAB) - Time. Select the Format which you prefer.

Thanks,
Satya

"pete3589" wrote:


I have an application in which I import data into excel and then graph
it on the y axis with the x axis being system time. I actually graph 3
Y values at once using a list selector.

When I begin importing data, I have a time column which the graph uses
to get the x axis. This is a time of day so it will read x:xx PM/AM.
However, for some reason when I start the data collection, the x axis
time wont change past 12:00 AM. As a matter of fact, it says 12:00AM
there for all values even before I start graphing, and it never
changes.

At one point this was working, but I made a few minor changes (which i
can't recall) and now it has stopped working. I have also double and
triple checked my ranges to make sure I am reading from the proper
cells.

Has anyone ever experienced this or know why this is doing this?


--
pete3589
------------------------------------------------------------------------
pete3589's Profile: http://www.excelforum.com/member.php...o&userid=28402
View this thread: http://www.excelforum.com/showthread...hreadid=494155