| T O P I C R E V I E W |
| bekasik |
Posted - 08/31/2007 : 05:28:45 AM
Origin Version (Select Help-->About Origin): 6.0
Operating System: Windows XP Pro
Hello, i would be pleased of any help.
I can't build proper 3D Graph.
What i need, must look like that (in MathCad:
http://img201.imageshack.us/img201/9366/mathcadir2.jpg
I'll tell step by step what i do:
1. That's how it looks in Excel (red, yellow and white are x,y,z axes)
http://img154.imageshack.us/img154/5124/excelal6.jpg
2. Now i import them in Origin
http://img53.imageshack.us/img53/2913/importedop8.jpg
3. Next step, convert those into matrix (edit > convert > direct)
http://img236.imageshack.us/img236/5310/matrixym8.jpg
4. And now i build the graph (3D Color Map)
http://img413.imageshack.us/img413/5890/graphww2.jpg
So, Y is OK. But with X and Y axes something isn't right. What do i need to do and what did i do wrong? Thanks.
Edited by - bekasik on 08/31/2007 06:28:41 AM |
| 1 L A T E S T R E P L I E S (Newest First) |
| Mike Buess |
Posted - 09/01/2007 : 02:49:36 AM
Your Excel worksheet is not in the proper format to convert to matrix. All values for one axis (X or Y) are in the first row and all values for the other axis (Y or X) are in the first column. You must rearrange the worksheet as XYZ columns before converting to matrix. Luckily there is an addon toolbar with a button that does exactly that manipulation. Download the Addon Tools from Origin's file exchange. If the setup instructions don't work you can install the addons manually like this...
1. Unzip all files in oaddon.exe to your Origin folder.
2. Close Origin and open Origin.ini in Notepad.
3. Add these two keys in the [UserDefinedButtons] section.
Worksheet Tools=oaddon1.ini
Graph Tools=oaddon2.ini
4. Start Origin and enter these two commands in the script window...
system.toolbar.create(Worksheet Tools);
system.toolbar.create(Graph Tools);
Use the first button (XYY to XYZ) on the new Worksheet toolbar to convert the worksheet from Excel to XYZ format. Then use Convert to Matrix> Regular or Random XYZ to create your matrix.
Mike Buess
Origin WebRing Member
Edited by - Mike Buess on 09/01/2007 03:02:33 AM |
|
|
