| Author |
 Topic  |
|
|
coll@inia.
Spain
125 Posts |
 Posted - 05/04/2014 : 5:29:00 PM
|
Origin Ver.8.5 win7
I am trying to show in a 3D bar graph, a series of Y values (expression levels) distributed in spots (X,Z) of a bidimensional diagram or pathway of genes (L) to visualize selected results of an expression microarray.
Also I would like to identify each of the spots by its name (L).
I enclose an example down the email.
Is it possible?
Thanks, julio
L X Z Y
a2m 300 400 0,81
cfb 625 650 1,56
c1q 275 700 1,09
c1s 325 700 5,05
c2 475 700 2,13
c3 550 550 6,14
c4 450 700 1,79
c6 800 800 1,53
c7 850 800 1,03
c8 900 800 4,76
c9 950 800 4,34
clu 700 850 0,9
crp 180 675 13,54
cfd 625 625 1,76
f10 500 200 2,25
f13 700 250 1,18
f2 650 200 5,74
f2r 950 75 1,04
f3 300 125 0,79
f5 500 225 3,41
f7 300 150 2,05
f8 300 200 0,4
f9 300 225 6,98
fg 850 150 5,56
h1 450 600 3,49
hbl4 180 800 3,46
igm 180 575 1,23
igz 180 600 1,25
tpa 700 400 1,04
plg 700 500 5,72
proc 500 325 1,61
pros1 500 350 0,97
serpina1 300 325 2,21
serpinc1 300 350 3,74
serpind1 550 100 4,75
serpine1 650 300 1,2
serpinf2 300 375 5,35
serping1 350 550 4,65
tfpia 450 100 0,97
vwf 300 250 0,8
f12 180 400 1
masp2 325 825 1
c1r 380 700 1
|
|
|
lkb0221
China
497 Posts |
Posted - 05/05/2014 : 09:45:20 AM
|
Hi,
In 8.5 Origin, 3D bar plot can only be created by matrix data. So you might need to find a way to turn your XYZ to matrix first.
BTW, is this what you want? It is created in 9.1, which does not have the limitation above.
Zheng
OriginLab |
 |
|
|
coll@inia.
Spain
125 Posts |
Posted - 05/06/2014 : 3:15:25 PM
|
THANK YOU ZHEN: that was exactly what I need!
Do you mean that I have to buy the version 9.1 to make that? It occur to me that I have to buy 8.5 because another problem could not be solved by 8.0 !. It looks like I always need something that is solved in the next version!!!!!
There is no way to convert that data to a matrix and use Origin 8.5 or 8.6?
Thanks again, sincerely, julio |
|
|
|
lkb0221
China
497 Posts |
Posted - 05/06/2014 : 4:24:38 PM
|
Hi,
It is still doable in 8.5...
You may need to build a matrix with these points only (other cells be missing values) and then make a 3D bar from it. Since your Y data is random-like, you may use your Z as Y and Y as Z. You can rotate the graph after plotting.
This kind of convert XYZ to matrix seems can only be done manually...
And there is no way to put labels on...
Zheng
OriginLab |
|
|
|
lkb0221
China
497 Posts |
Posted - 05/06/2014 : 4:34:38 PM
|
You can use thick drop lines in 3D scatter to let it looks like bar, though. But you still cannot add labels.
Actually there is no 3D label until 9.0 Origin.
You can add text objects as labels after making the graph, but this requires lots of manpower... |
|
|
|
coll@inia.
Spain
125 Posts |
Posted - 05/07/2014 : 03:19:22 AM
|
Thank you for your help, Zhen!
I will have to go into the matrix world then. I will try.
cheers, julio |
|
|
|
coll@inia.
Spain
125 Posts |
Posted - 05/07/2014 : 03:30:14 AM
|
ZHENG, sorry I just notice I spelled your name uncorrectly in the previous communications.
I checked information about 3D and it seems a very good idea to use wider drop lines in scatter 3D. The addition of manual text labels might not be too much work because I would need to label only those more significant.
However, I do not understand too much about matrixes. Not yet! Furthermore, I might have to use + and - axes for the expression values or logs. That is probably not without further problems....
I sincerely apologize, Julio |
|
|
| |
Topic |
|
|
|
3D graph for expression microarray pathway