| Author |
 Topic  |
|
|
oszkoa
Hungary
47 Posts |
 Posted - 05/08/2006 : 3:32:15 PM
|
Origin Version (Select Help-->About Origin): 7.5 SR5
Operating System: Windows XP Prof SP2 HUN
Hi,
I'd like to create a 3D graph by plotting data in a 3x3 matrix. The X values (columns) at which data were measured should be 2, 10 and 20, the corresponding Y values (rows) should be 5 exp 10-4, 1 exp 10-3 and 5 exp 10-3. The nine cells of the matrix are filled with measured data.
Could you please someone tell me how can I set these row/column values?
Thanks,
Oszkoa
|
|
|
Hideo Fujii
USA
1582 Posts |
Posted - 05/08/2006 : 6:19:40 PM
|
Dear Oszkoa,
For the sample graph below, you can make by the following procedure:
1) Make a worksheet(say, column A and B in Data2) an for the graph's axis labels. Set the Column Display of B to "Scientific", Decimal Places=0.
2 5E-4
10 1E-2
20 5E-3
2) For the 3X3 matrix, set the column and row numbers to 3 and 3 for both, and set the X and Y coordinates to from=1 to=3 for both. (Matrix:Set Dimensions menu) Put your cell values there.
3) Make a 3D graph, for example 3D color surface.
4) Double-click the axis, and in the Tick Labels tab, set Type=Tick Indexed Dataset, Dataset=Data2_A for X for Bottom axis, and Dataset=Data2_B for Right axis.
Hope this is what you are looking for.
--Hideo Fujii
OriginLab
|
 |
|
|
oszkoa
Hungary
47 Posts |
Posted - 05/09/2006 : 3:24:45 PM
|
Dear Hideo Fujii,
thank you very much for your help. Your suggestion is very similar to what I am looking for, but still not the real thing. First of all, after setting the tick labels as you proposed, the values (e.g. 2, 10 and 20) do not span the whole axis, but are grouping at one end of the axis instead. The major problem is, that they seem to be equally spaced, though 10-2 not equals 20-10 and 5E-3 minus 1E-3 not equals 1E-3 minus 5E-4.
Best regards,
Oszkoa |
|
|
|
Hideo Fujii
USA
1582 Posts |
Posted - 05/09/2006 : 5:07:28 PM
|
Dear Oszkoa,
Unfortunately, cells in a matrix (i.e. data points on the grids) are "equally spaced" on X-Y plane as the nature of matrix. Only possibility, I can think of, is to make the X-Y-Z data in a worksheet, then you can make a graph such as 3D scatter/trajectory plot.
--Hideo
|
|
|
|
Mike Buess
USA
3037 Posts |
Posted - 05/09/2006 : 5:28:01 PM
|
Hi Oszkoa,
You might consider using a larger matrix. I started with the XYZ wks below.
1. Select Edit > Convert to Matrix > Sparse XYZ and fill the resulting dialog as shown below.
2. Click OK to create a matrix. You can replace the missing values with zeros by entering the expression (%C)=%C==0/0?0:1 in the script window.
3. Don't know how you intend to plot the matrix but a 3D Bars plot makes since for these data.
Mike Buess
Origin WebRing Member |
|
|
|
oszkoa
Hungary
47 Posts |
Posted - 05/10/2006 : 3:47:25 PM
|
Hi Mike and Hideo,
thank you for your hints. Now it works fine. The difference from your solution was that I had to use Random XYZ at the conversion, because up to now I have a Z value only for the (20;0,005) pair and hence sparse XYZ conversion was rejected by Origin saying that my data are irregular.
Oszkoa |
|
|
|
Hideo Fujii
USA
1582 Posts |
Posted - 05/11/2006 : 10:30:00 AM
|
Just for those who read this thread later...
> I had to use Random XYZ at the conversion,
You notice that the current algorithms of random conversion do not generally preserve the original values of the given points in worksheet. Being this acceptable or not depends on the application. We would like to improve this limitation of the random conversion in a future version of Origin.
--Hideo
|
|
|
| |
Topic |
|
|
|
setting matrix column/row values