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
 xy error bars?		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

pazmush

14 Posts
Posted - 12/11/2008 :  9:10:07 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
hi, i'm new to origin and can't figure out how to plot xy error bars from an excell spreadsheet, can anyone help?

greg

USA
1379 Posts
Posted - 12/12/2008 :  10:01:17 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Plotting special cases directly from Excel can be tricky and there's more than one way. Here's the easiest:

  1. If your desired Excel sheet is not the first sheet:


    1. Make the desired sheet active

    2. Right-click the Title bar of the Workbook and choose Update Origin


  2. Click the New Graph button on the Standard toolbar

  3. Double-click the Layer1 icon in the upper left of the graph window

  4. Expand the Plot Setup dialog to show all 3 panels (blue arrow buttons)

  5. Select the Excel Workbook in the top panel

  6. Select your Plot Type in the middle panel

  7. Right-click on the table with all the check boxes and choose X Err Bars

  8. Use the check boxes to select your X,Y,XErr and YErr and click ADD

  9. Click OK
Go to Top of Page

pazmush

14 Posts
Posted - 12/12/2008 :  7:34:35 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
thanks very much that was very helpful, one more thing though, when you fit an straight line, how do you make it so the x and y errors are taken into account on the error of the gradient?
Go to Top of Page

Deanna

China
Posts
Posted - 12/15/2008 :  9:12:39 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

Origin haven't supported fitting with X error yet. As for Y error, you can first create a plot with Y error bars and then open the linear fit tool. If you are using Origin 8, you can also open the Linear Fit tool first, and then select the Y error range in the Input Data branch(http://www.originlab.com/www/helponline/Origin8/en/origin.htm#Regression_and_Curve_Fitting/Simple_Linear_Regression_Dialog.htm#Input_Data).

Deanna
OriginLab Technical Services
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