X-axis graph must be sorted by date and time!

[technesurge]

My datalogger creates a field with the date and time in the following format:



d/m/yyyy h:mm:ss AM/PM

For example:

x-axis: 6/18/2012 9:19:45 AM, y-axis: 1
x-axis: 6/18/2012 9:19:46 AM, y-axis: 2
x-axis: 6/18/2012 9:19:47 AM, y-axis: 3

I tried making a custom date and time format. I tried it access and excel... any suggestions?

[June7]

What is the issue? Why do you need custom format? What format did you try? Why didn't it work - error message, wrong results, nothing?

Provide code and/or file for analysis. Follow instructions at bottom of my post.