LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pete3589
 
Posts: n/a
Default Graphing error using Time as X axis.


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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to add a second x axis with same Y axis value in one plot Mike Charts and Charting in Excel 1 October 19th 05 08:42 AM
time scale axis HB1972 Charts and Charting in Excel 1 October 10th 05 03:34 PM
How to calculate Date & Time differences robs Excel Worksheet Functions 2 October 4th 05 04:22 PM
Secondary Axis Match Primary Axis Gridlines [email protected] Charts and Charting in Excel 1 July 31st 05 09:23 PM
Adding time damezumari Excel Discussion (Misc queries) 2 June 20th 05 08:35 PM


All times are GMT +1. The time now is 09:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"