| T O P I C R E V I E W |
| Kingatschet |
Posted - 12/12/2013 : 10:54:02 AM
Origin Ver. and Service Release (Select Help-->About Origin): 7.5 SR7
Operating System: Windows Server 2008
Hi all
I have a problem to show my data in a 3D plot. I've done a hemolysistest where a point who has a X,Y and Z value stands for a composition of a drug. The drug can have 4 components.
These are my compositions:
Name/ X/ Y/ Z/ Hemolysis (%)
Drug 1 50 0 0 100
Drug 2 40 0 0 70.64583333
Drug 3 30 0 0 60.64583333
Drug 4 25 0 0 62
Drug 5 20 0 0 51.375
Drug 6 12.5 0 0 50.02083333
Drug 7 6.25 0 0 27.72916667
Drug 8 3.125 0 0 1.479166667
Drug 9 1.25 0 0 0
Drug 10 0.46875 0 0 0
Drug 11 50 50 0 100
Drug 12 40 40 0 100
Drug 13 30 30 0 100
Drug 14 25 25 0 100
Drug 15 20 20 0 63.77083333
Drug 16 12.5 12.5 0 64.8125
Drug 17 6.25 6.25 0 48.04166667
Drug 18 3.125 3.125 0 32.72916667
Drug 19 1.25 1.25 0 4.1875
Drug 20 0.46875 0.46875 0 0
Drug 21 50 0 50 100
Drug 22 40 0 40 100
Drug 23 30 0 30 100
Drug 24 25 0 25 100
Drug 25 20 0 20 100
Drug 26 12.5 0 12.5 40.85416667
Drug 27 6.25 0 6.25 24.70833333
Drug 28 3.125 0 3.125 1.166666667
Drug 29 1.25 0 1.25 0
Drug 30 0.46875 0 0.46875 0
Drug 31 33 33 33 100
Drug 32 26.4 26.4 26.4 100
Drug 33 19.8 19.8 19.8 100
Drug 34 16.5 16.5 16.5 100
Drug 35 13.2 13.2 13.2 100
Drug 36 8.25 8.25 8.25 62.9375
Drug 37 4.125 4.125 4.125 35.33333333
Drug 38 2.0625 2.0625 2.0625 3.5625
Drug 39 0.825 0.825 0.825 0
Drug 40 0.309375 0.309375 0.309375 0
Drug 41 0 50 0 4.684210526
Drug 42 0 40 0 0
Drug 43 0 30 0 0
Drug 44 0 25 0 0
Drug 45 0 20 0 0
Drug 46 0 12.5 0 0
Drug 47 0 6.25 0 0
Drug 48 0 3.125 0 0
Drug 49 0 1.25 0 0
Drug 50 0 0.46875 0 0
Drug 51 0 0 50 53.98245614
Drug 52 0 0 40 0.824561404
Drug 53 0 0 30 0
Drug 54 0 0 25 0
Drug 55 0 0 20 0
Drug 56 0 0 12.5 0
Drug 57 0 0 6.25 0
Drug 58 0 0 3.125 0
Drug 59 0 0 1.25 0
Drug 60 0 0 0.46875 0
Drug 61 0 50 50 63.10526316
Drug 62 0 40 40 8.368421053
Drug 63 0 30 30 0
Drug 64 0 25 25 0
Drug 65 0 20 20 0
Drug 66 0 12.5 12.5 0
Drug 67 0 6.25 6.25 0
Drug 68 0 3.125 3.125 0
Drug 69 0 1.25 1.25 0
Drug 70 0 0.46875 0.46875 0
Each point has now a value of hemolysis from 0-100%. Now I want to color each point to the value of his hemolysis. So for example 100% is bad=red. 0% is good=green.
Is it possible in origin to make a graph like this?
Thanks for your help!!!!
|
| 4 L A T E S T R E P L I E S (Newest First) |
| lkb0221 |
Posted - 12/19/2013 : 1:56:15 PM
Hi, Kingatschet
From your data posted, I see it is a XYZ format worksheet (As in my screenshot, with three columns indicating X, Y, Z and Hemolysis).
1). Highlight col(C), col(D) and col(E) and select "Worksheet: Convert to Matrix: XYZ Griding..." from the menu.
2). Choose your gridding method and parameters in the dialog. You can see the result preview in the right panel.
3). Click "OK" and you will get a matrix.
4). Do for col(B), col(C) and col(E) again to get the second matrix and put them into the same MBook, as I said in previous post.
5). Then plot the surface with the first matrix and fill it by the second, as I said in previous post.
Zheng
Originlab |
| Kingatschet |
Posted - 12/19/2013 : 04:51:08 AM
Hi lkb0221
What do you mean with convent both XYZ data? I have just this table or? Or do I misunderstand something?
I have now the version 9.1 but I'm completly new in this software. Could you make it step by step?
Thanks a lot!
Kingatschet
quote:
Originally posted by lkb0221
Hi, Kingatschet
To plot a 3D surface with colormap form another dataset, we need to use matrix.
So first, convent both of your XYZ data to matrix by "Worksheet: Convent to matrix: XYZ Gridding". (To keep the value range fixed, you might need to use "random (Weighted Average)" or "Random (Kriging Correlation)" method) You can see the "Preview Result" tab to modify grid settings until you get what you want. You can take a look at the following DOC to choose the best way for convertion:
http://www.originlab.com/doc/Origin-Help/XYZGridding-Dialog
Then you will have two MBooks. Right click the window title of the MBooks that contain surface data and select "Show Image Thumbnails". Right click the small picture in the upper panel and select "Add". Copy&Paste the other matrix (colormap data) to this one.
Now, activate the surface data matrix, highlight all and plot a 3D surface. Double click the surface to open Plot Details dialog, go to "Fill" tab, and set "Contour fill form matrix" to be the colormap data matrix. The following is what I got:
We also have a picture in graph gallery talking about how to plot a color map matrix surface using values from another matrix:
http://www.originlab.com/www/products/GraphGallery.aspx?GID=214
Zheng
OriginLab
|
| Hideo Fujii |
Posted - 12/16/2013 : 1:09:10 PM
Hi Kingatschet
> Now I want to color each point to the value of his hemolysis. So for example
> 100% is bad=red. 0% is good=green.
If you are considering to make a scatter plot in 3D spa‚ƒe, you can manage the
colormap of the 3D scatter plot:
1) From XYZ columns, make a 3D Scatter plot.
2) In the Plot Details dialog, choose Symbol tab, and set the Color dropdown to the "Map"
with the selection of the column for the point values (in your case, hemolysis).
3) In the "Colormap" tab, arrange the map table so that 0 is mapped to RED,
100 to GREEN, others, say GREY. Please see the screenshot below.
--Hideo Fujii
OriginLab |
| lkb0221 |
Posted - 12/12/2013 : 11:46:08 AM
Hi, Kingatschet
To plot a 3D surface with colormap form another dataset, we need to use matrix.
So first, convent both of your XYZ data to matrix by "Worksheet: Convent to matrix: XYZ Gridding". (To keep the value range fixed, you might need to use "random (Weighted Average)" or "Random (Kriging Correlation)" method) You can see the "Preview Result" tab to modify grid settings until you get what you want. You can take a look at the following DOC to choose the best way for convertion:
http://www.originlab.com/doc/Origin-Help/XYZGridding-Dialog
Then you will have two MBooks. Right click the window title of the MBooks that contain surface data and select "Show Image Thumbnails". Right click the small picture in the upper panel and select "Add". Copy&Paste the other matrix (colormap data) to this one.
Now, activate the surface data matrix, highlight all and plot a 3D surface. Double click the surface to open Plot Details dialog, go to "Fill" tab, and set "Contour fill form matrix" to be the colormap data matrix. The following is what I got:
We also have a picture in graph gallery talking about how to plot a color map matrix surface using values from another matrix:
http://www.originlab.com/www/products/GraphGallery.aspx?GID=214
Zheng
OriginLab |
|
|
