| T O P I C R E V I E W |
| sebowski |
Posted - 06/29/2010 : 03:36:14 AM
Origin Ver. and Service Release (Select Help-->About Origin): pro 8.1G SR3
Operating System: Win 7 64bit
I have data that looks like this
1,60206 1,00088 22,31621
1,50384 0,95771 31,5369
1,436 0,96101 17,99828
1,4236 0,98988 9,64511
1,346 0,85708 9,43838
1,40052 1,00052 15,73309
the first column is X, the second y and the third is z.
I would like to plot the data as a 3D Column plot.
The problem is, that x and y are spaced uneven, if i convert it to a matrix the result isn't as accurate as i would like it to be because my amount of data points isn't that big. If i convert it to a pivot table x is spaced correctly but y is not recognized as number and therefore not spaced correctly. What can I do?
sincerely yours |
| 2 L A T E S T R E P L I E S (Newest First) |
| sebowski |
Posted - 07/08/2010 : 6:41:46 PM
Thank you! It worked! I had to round and multiply the data so that it looked sth like this
x y z
160 120 600
instead of
x y z
1,6012 1,2032 6,0054
and then the sparse xyz gridding worked perfectly!
But you are right I am still not happy with the graph and think that an other way of displaying the data could be better... :) |
| DataConv |
Posted - 07/02/2010 : 02:34:11 AM
I'm not an expert for that - however, my suggestion:
Convert your data to a matrix with even spacing - sufficient fine stepping to meet your requirements (e.g. x=0.001 and y=0.001 stepping) and the boundaries with the x and y extremes (min and max) and filled with NaN's (or NA()'s). This will produce of course a large matrix... Then place the data you have in the matrix. Make your 3D plot. Since you will end up with small piles, just adjust the size (or other properties) to enlarge them visually...
Uneven distributions are always troublesome, the best way is to shift them to evenly spaced ones...
Or is it really necessary to use the 3D plot? No other way of visualization? |
|
|
