The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 3D Column plot with uneven spaced x and y
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

sebowski

6 Posts

Posted - 06/29/2010 :  03:36:14 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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

DataConv

Germany
60 Posts

Posted - 07/02/2010 :  02:34:11 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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?
Go to Top of Page

sebowski

6 Posts

Posted - 07/08/2010 :  6:41:46 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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... :)
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000