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
 Problems with 3D Graph		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

bekasik

Posts
Posted - 08/31/2007 :  05:28:45 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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

Mike Buess

USA
3037 Posts
Posted - 09/01/2007 :  02:49:36 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
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