| Author |
 Topic  |
|
|
dguru1
India
1 Posts |
 Posted - 12/16/2002 : 11:21:26 AM
|
Hi
I am a novice for origin . I have got every minute data for 30 days i.e 30*1440 . Iwant to plot a 3D by converting the data to RANDOM XYZ .
MY DATA STRUCTURE
01-11-02 02-11-02 .......... 30-11-02
00:01 51 45 .......... 49
00:02 54 57 ...... 53
.
.
24:00 43 52 ............... 59
Can some one help
Regards
GURU
|
|
|
easwar
USA
1964 Posts |
Posted - 12/16/2002 : 4:51:02 PM
|
Hi GURU,
If I understand this correctly, you have data in a worksheet where the first row of the worksheet has regularly spaced dates (such as 01-11-02) and the first column has regularly spaced time (such as 00:01) and then the remaining cells undeneath the first row and to the right of the first column has your data.
You could do the following:
1> duplicate the worksheet (right-click on title bar of window and choose Duplicate
2> Go to the duplicate
3> Delete the first column
4> Delete the first row
You are now left with just the Z values
5> Use the menu item Edit->Convert to Matrix->Direct
6> Select the matrix window that gets created, and use the Plot menu to select your plot type (such as 3D Surface or Contour etc).
You will now have your plot.
Note that for 3D plots, axis is assumed to be numeric - does not support date/time etc. To use your date and time information to annotate the axis labels, you can do the following:
7> While matrix is active, go to Matrix->Set Dimensions dialog and make sure your col and row dimensions match the col and row coordinate settings
8> Open a new worksheet and copy the first col with times from your original datasheet, to the first col of your new worksheet. Copy the 1st row from your original datasheet and then paste-transpose this to the second col of the new worksheet
9> Go to your 3D plot and double-click on the x axis
10> Go to Tick Labels tab, and from the Type drop-down list, choose Tick Indexed Dataset
11> In the Dataset drop-down list, point to the second col of the newly created worksheet, that has your original month text
12> Repeat the same for the other axis, but now using the 1st col of the new worksheet that has your time text
Hope this helps. If not, please send your data to your tech support contact, and they can help you make the plot.
Easwar
OriginLab.
Edited by - easwar on 12/16/2002 4:55:37 PM |
 |
|
|
greg
USA
1378 Posts |
Posted - 12/24/2002 : 10:46:11 AM
|
Actually, 3D plotting with Date or Time as an axis is directly supported, but there's a bit of quirkiness ...
Go to Tools : Options : [Numeric Format] and boost the 'Upper Threshold Power' to 12. That forces Origin to display more digits before using Scientific notation. After that change, you can set the Matrix XY mapping to the rather large Julian values needed for Date-Time and the Matrix won't choke.
Your Date format is not supported by the DATE( ) function yet (it will be soon), but you can get a Date-Time numeric value using:
value1 = date(11/1/2002 00:00);
value2 = date(11/30/2002 23:59);
type From $(value1,%16.8f) to $(value2,%16.8f);
which yields:
From 2452579.00000000 to 2452608.99930556
So you can set your X mapping from 2452579 to 2452608
and your Y mapping from 0 to .9930556
(or rather 1/3600 to 1 for 1 minute to 24 hours)
Once plotted, double-click on the X Axis Tick Labels and choose Date as the format, then double-click on the Y Axis Tick Labels and choose Time as the format.
|
|
|
| |
Topic |
|
|
|
HOW TO PLOT 3D