| Author |
 Topic  |
|
|
cvhorie
United Kingdom
32 Posts |
 Posted - 09/27/2009 : 11:07:27 AM
|
Origin Ver. and Service Release 8 SR 6
Operating System: XP
I am trying to plot a set of data from 18:00 to 6:00 at 30min intervals, with column A X-axis declared as time, i.e. an overnight dataset. Origin did not recogise this period, and reordered the plot data in hour order, ignoring the column order. So I edited all the data to 000:18:00 to 001:06:00.
How can I get Origin to recognise these times? If I use the defaults, the data is plotted with the X-axis going from 16:48 to 31:12 with an increment of 1:24. If I scale the axis from 18 to 6 with increment of 2:00, the axis goes backward from 17 to 6, ticks at 16, 14, 12, 09, 07 and no data plotted.
PS the Y axis is fine (so far)
Velson Horie |
|
|
AmandaLu
439 Posts |
Posted - 09/28/2009 : 04:27:27 AM
|
Hi cvhorie,
1. If your dataset is evenly space (e.g. from 18:00 to 06:00 with a constant interval of 30min), we can plot the graph following the steps:
I. Suppose the original dataset contains two columns. col(A) is the x value, in the time format (hh:mm), col(B) is the y value. Create a blank graph window by click the New Graph button in the standard toolbar.
II. Open the Plot Setup dialog by selecting Graph: Plot Setup.
III. In the dialog open, select the <autoX> column as X, col(B) as Y. Click OK to plot a graph.
IV. Double click the X axis to open the X Axis dialog box. On the Tick Labels tab, select Text from dataset from Type drop-down list. Then select col(A) from the Dataset drop-down list.
2. If your dataset is not evenly space, we can use a piece of LT script to convert the data format. Also suppose your data contains two columns. col(A) is X value. Make sure its format is time (hh:mm). col(B) is y value. Please run the following script in the command window.
range aa=col(a);
nSize=aa.getsize();
aa.format=7;//set col(a)s format as Text & Numeric
for(ii=1;ii<=nSize;ii++)
{
if(aa[ii]>aa[ii+1]) {loop(jj,ii+1,nSize) (aa[jj]+=1;)}
}
aa.format=3;
aa.subformat=14;//set col(a)s format as ddd:hh:mm
Now you can plot your graph.
Double click the X axis to open the X Axis dialog box. On the Tick Labels tab, select a display format you like from the Display drop-down list.
|
Edited by - AmandaLu on 09/28/2009 04:54:28 AM |
 |
|
|
cvhorie
United Kingdom
32 Posts |
Posted - 09/28/2009 : 07:36:51 AM
|
Thank you
I tried two ways to follow your guidance. The data is evenly spaced at 30 min intervals, so I have tackled just the first method I to IV.
1. With the time data in the format 000:18:00 to 001:06:00, following the steps, the X-axis shows only the single label 000:18:00 in the middle of the axis. The scale (0.7-1.3 presumably days), interval etc settings seem very peculiar and do not reflect the data and when they are changed, the X-axis scale transforms to a reverse order (and no plotting).
2. With the time data edited to the format 18:00 to 06:00, following the steps, the X-axis shows only the single value 18:00 as a label at the right end of the axis. And the points are plotted according to value not their position in the column series.
This is the data set I am using.
18:00 67
18:30 68
19:00 70
19:30 69
20:00 68
20:30 67
21:00 64
21:30 59
22:00 58
22:30 52
23:00 54
23:30 58
00:00 59
00:30 60
01:00 60
01:30 60
02:00 60.5
02:30 61
03:00 61
03:30 61.5
04:00 62
04:30 62
05:00 62.5
05:30 63
06:00 63.5
-- --
-- --
-- --
Velson Horie |
|
|
|
cpyang
USA
1406 Posts |
Posted - 09/28/2009 : 1:30:46 PM
|
Your data does not include date part so there is no way Origin can know 00:00 is after 23:00. Is it possible to add the full date part so your data will look like
2009.06.01 23:00
2009.06.02 00:00
CP
|
|
|
|
cvhorie
United Kingdom
32 Posts |
Posted - 09/28/2009 : 2:47:31 PM
|
I had also used this data set below which at least plotted the points in order but with not much better results on the axis (as I described in 1 above)
000:18:00 67
000:18:30 68
000:19:00 70
000:19:30 69
000:20:00 68
000:20:30 67
000:21:00 64
000:21:30 59
000:22:00 58
000:22:30 52
000:23:00 54
000:23:30 58
001:00:00 59
001:00:30 60
001:01:00 60
001:01:30 60
001:02:00 60.5
001:02:30 61
001:03:00 61
001:03:30 61.5
001:04:00 62
001:04:30 62
001:05:00 62.5
001:05:30 63
001:06:00 63.5
Your suggested format, 2009.06.01 23:00, was not recognised. When I changed it to 090601 18:00, this was recognised. The plot was a single vertical line in the middle of the axis on which all the points were compressed. The axis seemed to be a couple of years long and did not respond well to rescaling, 090601 18:00 to 090602 06:00 - the points and the tick labels disappeared.
Velson Horie |
|
|
|
cpyang
USA
1406 Posts |
Posted - 09/28/2009 : 4:37:07 PM
|
Using IRIG time seems to be the best idea! We will need to fix the axes dialog to recognize IRIG time, as that seems to be the key bug here.
We will try to fix this for 8.1, thanks for reporting. So this is the format that we will make sure can work
000:18:00 67
000:18:30 68
000:19:00 70
000:19:30 69
000:20:00 68
000:20:30 67
000:21:00 64
and set col to Time, DDD:HH:mm
Right now, if you set the X axis to Time with hh pm and set the scale to be from 17:00 with increment of 02:00, it seems to work ok?
CP
|
|
|
|
cvhorie
United Kingdom
32 Posts |
Posted - 10/02/2009 : 3:16:26 PM
|
Thank you. Following your advice, my data from 6pm to 6am is successfully plotted to produce a plot on X axis from 4pm to 7am next day.
However.. If I change the scale to 6pm to 6am (the period of the data) >Apply, the scale is automatically changed to 12am to 12am, and the data plot scale is changed to 12 am to 12pm, a 24 hour period. Only the data from 6pm to 12pm is plotted, squeezed into the far right hand side.
You are right about a bug in the axes calculations.
Velson Horie |
|
|
| |
Topic |
|
|
|
plotting time X axis, 18:00 to 6:00