DPlot Forum Index DPlot
http://www.dplot.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Date formats from Excel

 
Post new topic   Reply to topic    DPlot Forum Index -> Bug Reports
View previous topic :: View next topic  
Author Message
kornfein



Joined: 03 Feb 2006
Posts: 3

PostPosted: Tue Aug 15, 2006 8:18 am    Post subject: Date formats from Excel Reply with quote

It appears that date columns must be in the format of 01/01/2006 12:00 and not 01-01-2006 12:00. When there are dashes in the date format DPlot gets confused and reads only the time portion of the date.
Back to top
View user's profile Send private message
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2310
Location: Vicksburg, Mississippi

PostPosted: Tue Aug 15, 2006 8:52 am    Post subject: Reply with quote

At first glance this is only a formatting problem that you could correct by right-clicking on the date axis in DPlot and selecting the appropriate Date format. Unfortunately when the Add-In decides that your values are times (as opposed to date/time pairs) it multiplies your values by 24 to get from Excel's 24 hrs=1.0 to DPlot's 24 hrs=24. So your data will be all fouled up.

I'll correct the Add-In to look for "m-" in addition to "m/" in the formatting string. In the meantime you can correct the problem in DPlot by first setting the Default number format (right-click on the labels along the X axis, select "Default format"). Then shift X back to the original values with Edit>Operate on X w/ X=X/24. And finally right-click on the X axis again and choose "Date and Time".
_________________
Visualize Your Data
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    DPlot Forum Index -> Bug Reports All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group