Origin Tutorial
Contents
1. Uniform Same as Fitting Data Begin Independent Var End Points Dosi lt 7 farsa feo O Mane Eom Create Curve Basic Mode 3 Click Create Curve The parameters you typed in the text boxes are used to create a curve which is plotted in the graph window containing your data plot 44 e 4 5 Fitting a Dataset Using Your Own Function Tutorial 4 Nonlinear Curve Fitting Figure 4 8 Simulated Curve You can type new parameter values in the text boxes to create a simulated curve which looks more like your data 4 Type 10 in the PI text box overwriting 5 5 Click Create Curve 6 Type 1 in the P2 and P3 text boxes overwriting 5 7 Click Create Curve 4 5 Fitting a Dataset Using Your Own Functione 45 Tutorial 4 Nonlinear Curve Fitting Figure 4 9 Fine tuning the Simulated Curve The simulated curve is much more similar to the plotted data with the last set of parameter values These will be the initial parameter values when Origin fits the data Fitting the Data You will now fit the data using the function you defined The initial parameter values will be used from the Simulate Curves dialog box To Fit the Data 1 Select Action Fit from the NLSF menu bar 2 Click Chi Sqr The chi squared value for the current parameter values displays in the view box 3 Click 10 Iter 46 4 5 Fitting a Dataset Using Your Own Function Tutorial 4 Nonlinear Cu2. g FA Copy 05 1 2192 0 22 5 GB Paste A9 1 2192 0 26 af Baste ink 0 25 5 16 1 2192 0 32 Gi Insert dA 1 2192 0 4 Li Delete 50 1 2192 0 38 Bl cea EY e Set as End 2 Statistics on Row DCO Mask Use the vertical scroll bar to move down in the worksheet so that row number 68 is visible Right click on the row heading for row number 68 Select Set As End from the shortcut menu that opens Notice that the data outside the selected range is no longer displayed in the worksheet The data has not been deleted from the worksheet only hidden to provide for easier viewing of the selected range The hidden data can be shown by selecting Edit Reset to Full Range Plotting the Data 1 Click the FLUOR column heading to select the column 2 Drag the horizontal scroll bar on the bottom of the worksheet all the way to the right CTRL click on the TEMP column heading This selects the TEMP column while leaving the FLUOR column selected 16 e 2 4 Plotting a Range of the Worksheet Data Tutorial 2 Exploring Your Data 4 Click Double Y Axis on the 2D Graphs Extended toolbar To open the 2D Graphs Extended toolbar select View Toolbars select the 2D Graphs Extended check box then click Close Figure 2 6 Plotting a Range of Worksheet Data El Graphi Mil ES Y1 Axis Title SUL SET GA A Axis Title 2 5 Masking Data in the Graph The Mask toolbar 1s provided for excluding data fro
3. Select Analysis Fit Linear An updated fit line is drawn on the graph Verify that the mask is disabled by comparing the two fit results in the Results Log 20 e 2 6 Performing a Linear Fit on the FLUOR Data Plot Tutorial 2 Exploring Your Data Figure 2 10 Linear Fit of Data with Mask Disabled O FLUOR Linear Fit of TUTORIAL2 FLUOR Y1 Axis Title SUL SET CA A Axis Title 2 7 Saving the Project Your Origin project currently consists of your data worksheets graph analysis results and the current folder organization in the Project Explorer To Save the Project 1 Select File Save Project 2 Type aname in the File Name text box 3 Click Save 2 7 Saving the Project 21 Tutorial 2 Exploring Your Data This page is left intentionally blank 22 e 2 7 Saving the Project Tutorial 3 Creating Multiple Layer Graphs Tutorial 3 Creating Multiple Layer Graphs 3 1 Introduction This tutorial will introduce you to Origin s built in multiple layer graph templates It will also show you how to create your own multiple layer graph and then save it as a template 3 2 Opening the Project File The data for this tutorial is provided in a project file To Open the Project File 1 Click Open on the Standard toolbar 2 In the Origin 6 0 TUTORIAL folder select TUTORIAL_3 OPJ from the list of files 3 Click Open A project containing four graph windows and a worksheet opens
4. 3 3 Viewing Origin s Multiple Layer Graph Templates Origin contains several built in multiple layer graph templates These templates allow you to select a range of data then click a button to plot the selected data into multiple layers in a graph window 3 1 Introduction e 23 Tutorial 3 Creating Multiple Layer Graphs The double Y axis graph template is ideal for plotting data that includes two or more dependent datasets and a common independent dataset A sample double Y axis graph is currently active in your project 1 Right click on the double Y axis graph window title bar and select Hide from the shortcut menu The Project Explorer provides easy access to all the windows in the project By default the Project Explorer is docked at the bottom of your workspace If you cannot see the five icons on the right pane of the Project Explorer then expand the view by pointing the mouse on the upper edge of the Project Explorer When the mouse pointer displays click and drag upward so that you can see all five icons on the right pane Note If your Project Explorer is closed click amp a on the Standard toolbar Figure 3 1 The Project Explorer Cia iioa 3 i e Pare Graph Wine HKE 12923 4252 D Ej Doberak Giaphi Mona zatB Tien az O 8 Horizonte Pere Graph Mow EA ie 1222 0 LAYERS Wokehesd o Mininiz SERBO N2380 1202 d Webco EP ane Graph Wins ZED ie 1252 O 2 Double click on the Horizontal2Pane
5. importing ASCII 1 multiple X columns 25 NLSF results 47 plotting range 15 17 setting column values 12 setting display range 15 16 sorting 13 Index e 81
6. 4 5 Fitting a Dataset Using Your Own Functione 49 Tutorial 4 Nonlinear Curve Fitting This page is left intentionally blank 50 e 4 5 Fitting a Dataset Using Your Own Function Tutorial 5 Creating 3D Surface Graphs Tutorial 5 Creating 3D Surface Graphs 5 1 Introduction For more information on 3D graphs see the plotting chapters in the Origin User s Manual Origin supports 3D graphs from three different data formats XYY worksheet data X YZ worksheet data and matrix data However 3D surface graphs can only be created from matrix data This tutorial will focus on converting a worksheet containing XYZ data to a matrix and then creating and customizing a 3D surface graph from the matrix 5 2 Converting a Worksheet to a Matrix In this section you will learn how to change a worksheet column s designation then convert an X YZ worksheet to a matrix so that it can be plotted as a 3D surface graph The data for this lesson is provided in an ASCII file To Import the ASCII File 1 Click New Project on the Standard toolbar 101 2 Click Import ASCII BB on the Standard toolbar 3 In the Origin 6 0 TUTORIAL folder select TUTORIAL_5 DAT from the list of files Click Open 5 1 Introduction e 51 Tutorial 5 Creating 3D Surface Graphs Figure 5 1 Importing the ASCII File 88 TUTORIALS 2 55356 43 65282 1 5 __5 1072 18 96488 _ 2 655E 6 __7 6608 _ 0 50993 _2 705E 6 12 768 40
7. Figure 4 4 Advanced Mode of the NLSF Categories Functions Origin Basic Functions da Chromatography Beta Exponential Boltzmann Growth Siqmoidal Dkyperbl Classical Freundlich Model hat been used in the study of allometry Sample Curve Function File Display function s equation Basic Mode 4 5 Fitting a Dataset Using Your Own Function Opening the Project File The data for this tutorial 1s provided in an Origin project file To Open the Project File 1 Click Open on the Standard toolbar 2 In the Origin 6 0 TUTORIAL folder select TUTORIAL_4 OPJ from the list of files 3 Click Open 40 e 4 5 Fitting a Dataset Using Your Own Function Tutorial 4 Nonlinear Curve Fitting The project opens showing a worksheet containing data and a graph window containing a data plot Defining a Function You can define your own function in the NLSF and then access that function in future sessions from the fitter s Functions list box In the basic mode you click New to define a function The following procedure guides you through defining a function in the advanced mode To Define your own Function in the Advanced Mode 1 Select Analysis Nonlinear Curve Fit If the fitter opens in the basic mode click More Select Function New from the NLSF menu bar Type MyFitFunc in the Name text box Select 3 from the Number of Parameters drop down list Type p1 exp x p2 p3 in the Definitio
8. Label Clear Title 1 Close Id lat Into Single Layer T l TT Close dialog after plot Select a range ot data then click one of the above buttons to designate the appropriate data type forthat range The box below the buttons shows the data ranges representing the data types X A1 A65536 means that the X data is being represented by column A rows 1 to 65536 The last row number of the column 1s shown because you selected the whole column 5 Click Plot in the Select Data for Plotting dialog box then click Close 6 Reposition the legend so that the entire legend is on the graph page 7 3 Plotting an Excel Workbook in Origine 73 Tutorial 7 Working with Excel in Origin Figure 7 3 Plotting Excel Data Using the Select Data for Plotting Dialog Box Crude oil imports million barrelsfday S Crude oil exports million barrels day Y Axis Title 1955 Axi Title Creating a Data Plot by Dragging Data Into a Graph When you drag Excel workbook data into a graph Origin makes assumptions about the plotting designations of the selected data If one column or a range from one column is highlighted then this column supplies the Y values for the data plot The data 1s plotted versus row number If more than one column or a range from more than one column is highlighted the leftmost column supplies the X values All other columns supply the Y values The data
9. You can switch between modes by Origin User s Manual clicking the More button in the basic mode or the Basic Mode button in the advanced mode The Basic Mode The basic mode of the curve fitter provides an abbreviated fitting function list and a less complex interface than the advanced mode Additionally the basic mode offers less control over the fit and less customization of the reported results 38 e 4 3 Fitting Using the Tools Tutorial 4 Nonlinear Curve Fitting Figure 4 3 Basic Mode of the NLSF NonLinear Curve Fitting Select Function PA s EI Functions f Equation C Cure Boltzmann Ohyperbl ch Classical Freundlich Model has been used in the study of allo Start Fitting Select Dataset More Close The Advanced Mode The advanced mode lets you customize all aspects of the fitting process It provides access to many more fitting functions than the basic mode and the functions are separated into categories to facilitate searching The advanced mode also has its own menu and toolbar to provide access to all its features To select a function in the advanced mode select the appropriate category from the Categories list box then select the desired function from the Functions list box Once a function is selected the procedure for fitting 1s the same as for fitting after you define your own function 4 4 The Nonlinear Least Squares Fittere 39 Tutorial 4 Nonlinear Curve Fitting
10. box Similar to the Plot Details dialog box you can specify the axis you see Chapter 10 in the want to customize by selecting it from the Selection list box on the left Origin User s Manual side of the dialog box To Customize the Axes 1 Double click on the X axis 2 On the Scale tab type 1 2 in the From text box 1 8 in the To text box and 1 in the Increment text box Figure 1 6 The X Axis Dialog Box Axis Layer 1 Tick Labels Minor Tick Labels Custom Tick Labels Scale Title amp Format Grid Lines Break Selection From fi 2 Increment 1 To j s Major Ticks Type Linear Minor Ticks 1 Fescale j Mata zl First Tick I Show asic Ma wr TE Cancel Apply Select the Title amp Format tab Type Time sec in the Title text box overtyping the default text Select the Left icon from the Selection list box Type Potential mV in the Title text box overtyping the default text 6 e 1 5 Customizing the Graph Tutorial 1 Plotting Your Data 7 Select the Scale tab 8 Type 001 in the From text box 014 in the To text box and 002 in the Increment text box 9 Click OK Figure 1 7 Customizing the Graph E Graph Go o Testi mW Test mW Tests mW Potential mv B o O Pa Time sec Adding Text to the Graph To further customize your graph you can add annotations including text arrows l
11. box in the lower right corner of the layout page 6 2 Adding Graphs Worksheets and Text to the Layout Pagee 65 Tutorial 6 Creating Presentations with the Layout Page Figure 6 2 Adding a Worksheet Picture to the Layout Page Ga Layout To Add Text to the Layout Page using the Text Tool Click Text Tool on the Tools toolbar Click on the upper portion of the layout page then type Peaks from Spectroscopy Data in the Text Control dialog box Select 36 from the Size combination box Select Black Line from the Background drop down list Click OK 66 e 6 2 Adding Graphs Worksheets and Text to the Layout Page Tutorial 6 Creating Presentations with the Layout Page Figure 6 3 Adding Text to the Layout Page Ga Layout 6 3 Customizing the Appearance of the Layout Page In this section you will fine tune the size and position of the graphic objects displayed in the layout page In addition you will make changes to the source graph window to change the graph s appearance in the layout page Arranging Pictures on the Layout Page There are several ways to arrange pictures on the layout page You can drag the pictures and estimate the position use the Object Edit toolbar or view the grid on the layout page and align the pictures using the grid lines as a guide To Arrange the Pictures on the Layout Page Using a Grid 1 Select View Show Grid 2 Right click on the graph picture then select Ke
12. is plotted versus the X values If more than one column or range from more than one column is highlighted and the CTRL key is depressed while dragging the data then all the columns supply the Y values The data is plotted versus row number To Create a Graph Using the Drag and Drop Method 1 Click New Graph Ie on the Standard toolbar Move the Graph2 window to the lower right corner of the workspace so that when the workbook is active it won t completely overlap the graph window 74 7 3 Plotting an Excel Workbook in Origin Tutorial 7 Working with Excel in Origin 2 Click on the title bar of the workbook to make it the active window 3 Select the first two columns in the workbook by dragging from the column A heading to the column B heading 4 Click on the right edge of the selected workbook data then drag the data to the Graph2 window When you release the mouse button column B is plotted against column A as a line plot in the graph window 5 Click on the graph window to make it the active window Figure 7 4 Dragging Data into a Graph Window El Graph 0 an FE REN T gt 1972 1974 1976 1979 1950 1952 1954 1956 1955 1990 1992 1994 1996 1996 x Axk Title Creating a Graph Using Origin s Default Plot Assignments This plotting method allows you to select your workbook data and graph type and then Origin creates the data plots by making assumptions about the plotting assignments
13. of the selected data This plotting method is not available by default It must be activated from the Options dialog box For a complete discussion on this feature see Chapter 4 in the Origin User s Manual 7 3 Plotting an Excel Workbook in Origine 75 Tutorial 7 Working with Excel in Origin To Create a Graph Using the Default Plot Assignments 1 Select Tools Options to open the Options dialog box If the workbook is active then select Window Origin Options 2 On the Excel tab select the Default Plot Assignments check box 3 Click OK then click No in the dialog box that opens 4 Make the Excel workbook active 5 Click on the column A heading then CTRL click on the column D and G headings 6 Click Area on the 2D Graphs toolbar 7 Reposition the legend so that the entire legend is on the graph page Figure 7 5 Plotting Excel Data Using the Default Plot Assignments AE Petroleum products imports million barrels day RA Petroleum products exports million barrels day Y Axis Title 1995 x Axi Title 76 e 7 3 Plotting an Excel Workbook in Origin Tutorial 7 Working with Excel in Origin 7 4 Saving an Excel Workbook in Origin There are two ways to save Excel workbooks in Origin projects You can save the workbook internal or external to the Origin project When you save a workbook internal to the project it is saved as part of the Origin project and can only be opened by opening
14. the Layer tool you can select menu commands from the Edit menu or from a shortcut menu available outside of the graph page but within the window Arranging Layers in the Graph Window In this section you will add and arrange layers to set up a vertical 2 panel graph with left and right Y axes To Add and Arrange Layers in the Graph 1 Select Edit Add amp Arrange Layers 2 In the Total Number of Layers dialog box leave the default of 2 Rows and 1 Column Click OK Origin asks for permission to create 1 more layer Click Yes Click OK in the Spacing dialog box to accept the default settings 28 e 3 5 Creating a Multiple Layer Graph Tutorial 3 Creating Multiple Layer Graphs Figure 3 6 Adding and Arranging Layers 2 k ou Pi Y Axis Title Xx AXIS Title To Add the Right Y Controlling Axis to the Top Layer 1 With the layer 3 icon selected right click in the gray area of the graph window outside of the page 2 Select New Layer Axes Linked Right Y from the shortcut menu that opens 3 5 Creating a Multiple Layer Graph e 29 Tutorial 3 Creating Multiple Layer Graphs Figure 3 7 Adding a Right Y Axis to the Top Layer a E RE IL 4 5 Axe Tithe Y Axis Title A Axk Title Adding Data to the New Layers To add the data to layers 3 and 4 you will use the Layer n dialog box in the same way you added the data to layer 2 To Add Data to the New
15. the Z ax1s scale to begin from a lower value To Change the Z Axis Scale 1 Select Format Axes Z Axis to open the Z Axis dialog box 2 In the From text box type 1E 4 3 Click OK 60 e 5 4 Customizing the Graph Tutorial 5 Creating 3D Surface Graphs Figure 5 12 Changing the Z Axis Scale Graphi 0 00030 000025 000020 000015 0 00010 0 00000 0 00005 0 00010 The Z axis now displays a greater range below the surface graph This decreases the amount of overlap of the surface plot and the contour providing for a better visual presentation Changing the Perspective of the Graph When you create a 3D graph the 3D Rotation toolbar automatically opens This toolbar contains buttons for controlling the perspective of the 3D graph By rotating the graph you can further reduce the overlap of the surface plot with the contour and provide a better perspective for viewing the graph Figure 5 13 The 3D Rotation Toolbar 30 Ro 80 e aa ae fio To Rotate the Graph 1 Click Tilt Up hed on the 3D Rotation toolbar 2 Click Rotate Counterclockwise on the 3D Rotation toolbar 5 4 Customizing the Graph e 61 Tutorial 5 Creating 3D Surface Graphs Figure 5 14 Rotating the Graph tern Mel ES 0 00030 000025 000020 0 00015 L j 47 Le Mn 000010 rH o 00008 Domo T 1 00005 0 000109 This new perspective eliminates the overlap between the surfac
16. 6861 3 155E 7 __15 3216 36 13428 1 927E 6 __17 8752 16 20608 5 202E 6 __20 4288 4 96125 2 614E 6 9 22 9824 22 80867 8 96E 7 By default when the file is imported columns are added to the worksheet as Y columns To convert the worksheet to a matrix it must be in an XYZ format To Change the Column Designation 1 Right click on the C Y column heading 2 Select Set As Z from the shortcut menu that opens Column C is now designated as a Z column Selecting the Type of Conversion For more information Origin provides several methods for converting worksheets to matrices on converting including direct expand columns 2D binning regular XYZ and random worksheets to matrices XYZ conversions The best method to use depends on the type of data in see Chapter 5 in the the worksheet Origin User s Manual The data in this lesson is an XYZ worksheet with un ordered XY data Thus the method of conversion you will use is random XYZ To Convert the Worksheet to a Matrix 1 Ifnot still selected click on the C Z column heading to select the column 2 Select Edit Convert to Matrix Random XYZ 52 e 5 2 Converting a Worksheet to a Matrix Tutorial 5 Creating 3D Surface Graphs 3 In the Gridding Parameters dialog box leave the default values in the text boxes then click OK The worksheet gets converted to a matrix Based on the default settings in the dialog box Matrix has dimensions of 10
17. Focusing on a Region of Your Graphic 3 l 5 lt Custonizim sithe Graplia least 5 Customizing the Data Plotino 5 CUS COMMIT ZITO GING darei 6 Caimi TexkioheGrapli detail T UB VIN VOUC PROS CCU ee a e e E R a a 9 Tutorial 2 Exploring Your Data 11 2a Od UON eee i a a a a a a a 11 22 Tran ormin Column Vales sea ia lealo 12 25 Srne WOrk SNEED iet i e e E 13 2 4 Plotting a Range of the Worksheet Data 15 2S Mask me Daa Une ap Eoee a a a ak domh benidantesen des tas 17 2 6 Performing a Linear Fit on the FLUOR Data Plot 19 Dl ANIC MPC Project AT 21 Tutorial 3 Creating Multiple Layer Graphs 23 De POG UC HOM oee eli ia ea 23 XZ Openmehe ProjeecHile c role lei leto 23 3 3 Viewing Origin s Multiple Layer Graph TemplatesS 23 3 4 Designating Multiple X Columns in the Worksheet 25 5 9 Cheatin amp a Multiple LayerGraphiip esta lello lil 25 Arranging Layers in the Graph WindoW ii 28 Adding Data to theNewLayefs i il iaia 30 Emens 31 3 6 Customizing the Legend oriens dilata 32 3 7 Saving the Graph as a Template e 34 Contents iii Contents Tutorial 4 Nonlinear Curve Fitting 37 2 R aE UC CLO a AA asic ae ly aia do etalon pea lg taal tan lon i 37 4 PA TONE MCN rrsi08 iin ico ysea yas daa pian vlan yine ai 37 aS Ein Osi the TOOS chien verse Gian daa visa a viae plas Nan Sunline Von yaeotel 38 44 The N
18. Layers 1 Double click on the layer 3 icon 2 In the Layer 3 dialog box select layers_potential2 in the Available Data list box then click gt to add it to the Layer Contents list box Click OK Double click on the layer 4 icon In the Layer 4 dialog box select layers_pressure2 in the Available Data list box then click to add it to the Layer Contents list box Click Layer Properties to open the Plot Details dialog box 30 e 3 5 Creating a Multiple Layer Graph Tutorial 3 Creating Multiple Layer Graphs 7 Double click on the Layer4 icon on the left side of the dialog box then click on the LAYERS Trial2 X Pressure2 Y data plot icon Figure 3 8 Graph Tree of Plot Details Dialog Box Graphi Layerl LJ Layer a Layers i i Layer LAYERS Tnial2 K Pr 8 Select Red from the Color drop down list 9 Click OK to exit the Plot Details dialog box 10 Click OK Linking Axes You can link axes between layers so that when you change the axis scale in one layer the other layer s linked axis updates to the same scale automatically To Link the X Axes 1 Double click on the layer 3 icon to open the Layer 3 dialog box 2 Click Layer Properties 3 Select the Link Axes Scales tab 4 Select Layer from the Link To drop down list 5 Select the Straight 1 to 1 radio button in the X Axis Link group then click OK Click OK in the Layer 3 dialog box 3 5 Creating a Multiple La
19. Li Fit Exponential Growth Fit Sigmoidal Fit Gaussian Fit Lorentzian Fit Multi peaks Li Non linear Curve Fit 4 1 Introduction e 37 Tutorial 4 Nonlinear Curve Fitting 4 3 Fitting Using the Tools For a greater degree of control than the menu commands allow Origin provides three fitting tools the Linear Fit tool the Polynomial Fit tool and the Sigmoidal Fit tool Figure 4 2 The Fitting Tools Polynomial Fit Sigmoidal Fit Operation Settings Operation Settings Operation ji Settings Through zero Error As Weight M Asymptotes Fix Fix Slope Error as Weight Scale Errors with SD Confidence Bands Prediction Bands Fit Use Chi Squared Confidence Bands Prediction Bands Initial 100 000 Final o a E A order 2 M Parameters Fix F Center 5 00000 I Rate 1 00000 Fit For more information The fitting tools are available when the worksheet or graph is active To on the fitting tools see use the fitting tools select the dataset or data plot you want to fit Chapter 16 in the customize the options on the tool and then click Fit Origin User s Manual 4 4 The Nonlinear Least Squares Fitter For more information The nonlinear least squares fitter NLSF is Origin s most powerful and on the NLSF see complex method of fitting data There are two display modes available Chapter 16 of the for the NLSF basic and advanced
20. Version 6 Tutorial Manual By Microcal Software Inc Copyright Microcal Origin and LabTalk are either registered trademarks or trademarks of Microcal Software Inc Microsoft Windows and Windows NT are registered trademarks of the Microsoft Corporation 1999 Microcal Software Inc All rights reserved The software including any images applets photographs animations video audio music and text incorporated into the software is owned by Microcal Software or its suppliers and is protected by United States copyright laws and international treaty provisions Therefore you must treat the software like any other copyrighted material e g a book or musical recording except that you may either a make one copy of the software solely for backup or archival purposes or b transfer the software to a single hard disk provided you keep the original solely for backup or archival purposes You may not copy the printed materials accompanying the software nor print copies of any user documentation provided in online or electronic form Grant of License This Microcal Software End User License Agreement License permits you to use one copy of the Microcal Software product Origin which may include user documentation provided in online or electronic form software on any single computer provided the software is in use on only one computer at any one time If this package is a license pack you may make and use additional copies
21. ating 61 A Adding aright Y axis 26 contours to 3D surface graphs 59 data to layers 27 layers 26 28 Arranging layers 28 ASCII importing Axes changing scale 60 customizing 6 Axis dialog box 6 C Changing axis scale 60 color map colors individual color 57 range 56 Color map changing colors individual color 57 range 56 changing levels 54 Columns changing designation 52 multiple X 25 selecting non consecutive 16 Index setting designation 2 setting values 12 sorting 13 Converting worksheets to matrices 52 Customizing axes 6 data plot color 27 data plots 5 mask color 18 the legend 32 D Data plots changing color 27 creating 3 customizing 5 fitting 19 masking data 17 Data points masking 17 Designating multiple X columns 25 E Enlarger tool 4 Error bars designating columns as 2 Excel opening workbooks 71 plotting default plot assignments 76 drag and drop 74 Select Data for Plotting dialog box 73 requirements 71 saving 77 F Fitting See also NLSF from the menu 19 linear 19 using the menu commands 37 using the NLSF 38 49 using the tools 38 G Graphs Index e 79 Index adding text 7 saving as templates 34 H Hiding windows 24 Hiding showing masked data 18 Importing ASCII 1 L Layer n dialog box opening 26 Layer tool 26 Layers adding 26 28 adding data to 27 arranging 28 linking 31 linking axes scales 31 removing data 48 Legends customizing 32 renami
22. columns by 10 rows Itis linearly mapped in X by columns and linearly mapped in Y by rows The correlation gridding method was used to compute the new Z values Figure 5 2 Converted Worksheet Data fae Matrixi 5 3 Creating a 3D Surface Graph Now that you have your data in a matrix you can create any type of contour or 3D surface graph For this tutorial you will create a 3D color mapped surface graph To Create a 3D Color Mapped Surface Graph 1 With the matrix active select Plot 3D 3D Color Map Surface The matrix data is plotted as a color map surface graph The different colors represent different Z value ranges 5 3 Creating a 3D Surface Graphe 53 Tutorial 5 Creating 3D Surface Graphs Figure 5 3 Color Map Surface Graph tern 0 00030 0 00025 0 0000 0 00015 in E 00000 re 0 0000 oomo I 004 5 4 Customizing the Graph Origin gives you full control over the color mapping applied to the surface data plot All the options for customizing the color map are located on the Color Map tab of the Plot Details dialog box Changing the Color Map Values The Color Map tab on the Plot Details dialog box displays the current color map associated with levels of Z values To edit an individual level or color click on the value or color in the Level or Fill column To edit the entire range of levels or colors click on the Level or Fill column heading To edit a range of levels SHIFT click on the desired
23. cted click Linked Right Y on the Layer tool This adds a second layer to the graph displaying only the right Y axis By default the X axis of this layer is linked to the X axis of layer 1 Double click on the layer 2 icon in the upper left corner of the graph window 26 e 3 5 Creating a Multiple Layer Graph Tutorial 3 Creating Multiple Layer Graphs 6 Select layers_pressurel in the Available Data list box 7 Click to add the dataset to the Layer Contents list box Figure 3 3 Adding Data to Layer 2 Layer Contents eo KK ressure BEIE ni by E barare Layer Properties layers_pressure2 Plot Associations Una Edit Range T Show Range MW Rescale on OF TT Show current folder only 8 Click Layer Properties The Plot Details dialog box opens 9 Double click on the Layer2 icon on the left side of the dialog box 10 Click on the LAYERS Trial1 X Pressurel Y data plot icon on the left side of the dialog box This action opens the Line tab Figure 3 4 Graph Tree of Plot Details Dialog Box 11 Select Blue from the Color drop down list then click OK 12 Click OK to close the Layer 2 dialog box 3 5 Creating a Multiple Layer Graph e 27 Tutorial 3 Creating Multiple Layer Graphs Figure 3 5 Adding a Right Y Controlling Axis Potentiali mV Y Axis Title s Axis Title Origin provides many methods to add layers to your graph In addition to
24. e of the Layout Page i 67 Arranging Pictures on the Layout Page i 67 Editing the Pictures in the Layout Page 69 O Expoftms theLayout Paseiullialalai 70 iv e Contents Contents Tutorial 7 Working with Excel in Origin 71 7 1 Introduction iii 71 7 2 Openings an Excel Work bOOK IM OPS Wigs gigia oa ipa 71 723 Plots am Excel Workbook MONS en n ia T2 Creating a Graph Using the Select Data for Plotting Dialog Box 72 Creating a Data Plot by Dragging Data Into a Graph i 74 Creating a Graph Using Origin s Default Plot Assignments 75 74 Savin ean Excel Workbook TE Orge T1 Index 79 Contents e v Tutorial 1 Plotting Your Data Tutorial 1 Plotting Your Data 1 1 Introduction This tutorial will show you how to import ASCII data into a worksheet plot the data and then customize some basic elements of the graph 1 2 Importing Your Data There are many ways to get your data into Origin If your data exists in an ASCII file you can import that file into an Origin worksheet For more information Origin can import almost any type of ASCII file just by selecting ting data n 121 i hath eee File Import Single ASCII or clicking Import ASCII L ES on the including multiple na i i ASCII files see Standard toolbar Origin examines the file looking for columns of data as well as column header text W
25. e plot and the contour and provides better visibility of the transparent section of the surface plot 62 e 5 4 Customizing the Graph Tutorial 6 Creating Presentations with the Layout Page Tutorial 6 Creating Presentations with the Layout Page 6 1 Introduction The layout page is designed to facilitate the creation of graphic presentations Pictures of any worksheet or graph windows in your project can be displayed and arranged on the layout page In addition text and graphic objects can be added to enhance your presentation 6 2 Adding Graphs Worksheets and Text to the Layout Page Pictures of graphs and worksheets are added to the layout page by clicking the buttons on the Layout toolbar or by selecting associated menu commands Text can be added with the Text tool or by pasting from the Clipboard Shapes lines and arrows can be added using the drawing tools from the Tools toolbar Opening the Project File The data for this tutorial lesson is provided in an Origin project file To Open the Project File 1 Click Open on the Standard toolbar 2 In the Origin 6 0 TUTORIAL folder select TUTORIAL_6 OPJ from the list of files 3 Click Open 6 1 Introduction e 63 Tutorial 6 Creating Presentations with the Layout Page A project opens displaying several worksheet and graph windows Creating a New Layout Page To Create a New Layout Page Click New Layout LE on the Standard toolbar A blank layout pa
26. ep Aspect Ratio from the shortcut menu that opens This will preserve the aspect ratio of the source graph window 6 3 Customizing the Appearance of the Layout Pagee 67 Tutorial 6 Creating Presentations with the Layout Page 3 Resize the graph picture using the right horizontal sizing handle to take up the lower left half of the layout page 4 Follow the same procedure for the worksheet picture resizing it to the lower right half of the layout page Note The grid is only displayed on the layout page within Origin If the layout page is printed or exported the grid will not be displayed Figure 6 4 Arranging the Objects on the Layout Page Ga Layout Peaks from Spectroscopy Data 5 Center the text label using the grid lines for alignment 68 e 6 3 Customizing the Appearance of the Layout Page Tutorial 6 Creating Presentations with the Layout Page Figure 6 5 Aligning the Text in the Layout Page Feaks from Spectroscopy Data Editing the Pictures in the Layout Page Although you cannot edit the worksheets and graphs in the layout page directly Origin provides a shortcut menu command to go to the source window To Edit a Source Window from the Layout Page 1 Right click on the graph picture in the layout page 2 Select Go To Window from the shortcut menu that opens Origin makes the Graph3 window active 3 Double click on the gray area of the Graph3 window outside of the page 4 O
27. ge opens If the layout page is displayed in the portrait orientation right click on the gray area of the layout page then select Rotate Page from the shortcut menu that opens Adding Pictures and Text to a Layout Page When you add a worksheet or graph to the layout page it is added as a graphic object and the features of the window cannot be edited directly in the layout page However all changes made to the original window will be reflected in the layout page To Add Pictures of Graphs and Worksheets to the Layout Page 1 Click Add Graph on the Layout toolbar If the Layout toolbar is not open select View Toolbars select the Layout check box then click Close Select Graph3 from list box in the Select Graph Object dialog box and click OK Drag out a box on the lower left corner of the layout page 64 e 6 2 Adding Graphs Worksheets and Text to the Layout Page Tutorial 6 Creating Presentations with the Layout Page Figure 6 1 Adding a Graph Picture to the Layout Page Ga Layout When you release the mouse button a picture of the graph window is added to the layout page When the graph picture is selected you can drag the picture to a new location or use the sizing handles to resize it Right click on a blank section of the layout page and then select Add Worksheet from the shortcut menu that opens Select Peaks from the list box in the Select Worksheet Object dialog box and click OK Drag out a
28. i ee STH Ascendng _ ete kissing but at Gori E males E Sekred Gurre Cancel OF 1 Largest TO Bridie al orks hest Selected Columra Hee Ttee_ o ATH Tad Hors TIME et b Aue DEPTH Ted 6 Hunar FLUOA Ted Hunan let 6 Hura 14 e 2 3 Sorting Worksheet Data Tutorial 2 Exploring Your Data Click OK De select the worksheet by clicking in the upper left blank space in the worksheet without the cursor changing to the downward pointing arrow The entire worksheet is sorted so that the values in the DEPTH primary column are ascending If there are two cells of equal value in the DEPTH column then the values in the corresponding rows of the STN secondary column are used to determine the worksheet order 2 4 Plotting a Range of the Worksheet Data You can set the worksheet display range so that subsequent plotting and analysis are performed only on the data of interest To Select a Range of the Worksheet Data 1 2 3 4 Select View Go To Row Type 52 in the dialog box that opens then click OK Right click on the row heading for row number 52 Select Set As Begin from the shortcut menu that opens 2 4 Plotting a Range of the Worksheet Datae15 Tutorial 2 Exploring Your Data Figure 2 5 Selecting a Range of Worksheet Data ses TUTORIAL lel Eo STNA TIME DEPTH FLUORIY cu EEI 1 2192 0 28 1251 2192 0 24
29. ick OK The expression you typed in the Set Column Values dialog box 1s used to update the values in the DEPTH column 2 3 Sorting Worksheet Data For more information Origin can sort individual columns multiple selected columns or entire on sorting see Chapter worksheets Origin offers simple sorting in which specified data is sorted 15 in the Origin User s using one sort by column and a selected sort order as well as nested Manual sorting To Sort the Worksheet Data 1 Move the mouse pointer to the upper left corner of the worksheet to turn the cursor into a downward pointing arrow see Figure 2 3 then click to select all the columns in the worksheet 2 3 Sorting Worksheet Data 13 Tutorial 2 Exploring Your Data Figure 2 3 Selecting All the Columns in the Worksheet 3 TUTORIAL2 Be Es TIMEMA MIA tal FLUOR Y A Click Sort on the Worksheet Data toolbar to open the Nested Sort dialog box To open the Worksheet Data toolbar select View Toolbars select the Worksheet Data check box then click Close Select DEPTH from the Selected Columns list box then click Ascending The column is added to the Nested Sort Criteria list box This selection makes DEPTH the primary sort column in ascending order Select STN from the Selected Columns list box then click Ascending This makes STN the secondary sort column in ascending order Figure 2 4 Sorting the Worksheet Nested Scat Chun So
30. ines and shapes The tools that let you add these annotations are located on the Tools toolbar Alternatively you can right click anywhere in the graph to add text using a shortcut menu To Add Text to the Graph Click on the Tools toolbar and then click on the top center position of the graph In the Text Control dialog box type Effect of Solvent Loss on Sample Potential 1 5 Customizing the Graph e 7 Tutorial 1 Plotting Your Data 3 Select 26 from the Size combination box Figure 1 8 The Text Control Dialog Box Text Control Background None Use System Font OK T Center Multi Li Rotate dea lo SL Cancel TT white Out Size 26 T Apply formatting to all labels in layer Set Default Tp Arial E black N Bl Z Ul T Effect of Solvent Loss on Sample Potential Ed di Effect of Solvent Loss on Sample Potential Click OK Drag the legend so that it is located in the top left corner of the graph next to the Y axis Drag the text label you just created so that it is centered at the top of the window 8 e 1 5 Customizing the Graph Tutorial 1 Plotting Your Data Figure 1 9 The Finished Graph EB Graphi BIS ES Effect of Solvent Loss on Sample Potential o Testi mv Test my ge Tests mv A Oo O 2 yi Potential gmi a n DO r 2 i HA FL 1 5 Time sec 1 6 Saving Your Project Your project currently consis
31. ith complex ASCII files Origin may need some help from you This help is provided in the Import ASCII Options dialog box Chapter 6 in the Origin User s Manual To Import the ASCII File 1 Begin this lesson by clicking New Project on the Standard toolbar 2 Click Import ASCII L HEY on the Standard toolbar 3 In the Origin 6 0 TUTORIAL folder select TUTORIAL_1 DAT from the list of files 4 Click Open The ASCII file imports into the worksheet The worksheet is renamed using the name of the ASCII file you imported Because the file contains text in the first two rows the first row of text is used to rename the columns while the first and second rows of text are used to create column labels The labels are used for the text in the legend when a graph is created 1 1 Introduction e 1 Tutorial 1 Plotting Your Data Note You may need to resize the worksheet to see all the columns Figure 1 1 Importing the ASCII file E TUTORIAL BE Timet z Testi Erori Teat Emo Teati ik Em LI m mi m 0 071 4 3624 EIME 5 106E 4 256355 JOTEA L5J6E5 TAL 4 FE IzE A4 Z50655 2 F797C 4 1 39965 El 1 3 Designating Worksheet Columns as Error Bars When you import data into a worksheet the default column designations of X Y Y Y etc are used to show data associations If your data is associated differently you can manually set the column designations In this example the data has the following associa
32. l graph icon on the right pane of the Project Explorer The horizontal 2 panel graph template 1s ideal for plotting related data that does not share an independent dataset You can use the Edit Add amp Arrange Layers menu command and the Layer tool to customize the spacing of the layers and to swap the layer arrangement Right click on the Horizontal2Panel graph icon on the right pane of the Project Explorer and select Hide Window from the shortcut menu Double click on the Vertical2Panel graph icon on the right pane of the Project Explorer 24 e 3 3 Viewing Origin s Multiple Layer Graph Templates Tutorial 3 Creating Multiple Layer Graphs The vertical 2 panel graph template provides the same data presentation as the horizontal 2 panel graph template but in a one column with two rows configuration 5 Right click on the Vertical2Panel graph icon on the right pane of the Project Explorer and select Hide Window from the shortcut menu 6 Double click on the 4Panel graph icon on the right pane of the Project Explorer A 4 panel and a 9 panel not shown graph template complete the library of built in multiple layer graph templates 3 4 Designating Multiple X Columns in the Worksheet When your worksheet includes multiple X columns Y columns in the worksheet plot against the nearest X column to the left Though this default behavior can be disregarded by plotting using the Select Columns for Plotting dialog box and by selec
33. location where it does not overlap with the axes or the data The legend now displays the data plot type representations from all the layers in the graph To prevent Origin from overwriting your custom legend for example if you click New Legend S on the Standard toolbar you can rename the legend by right clicking on the object and selecting Label Control To Rename the Legend 1 Right click on the legend 2 Select Label Control from the shortcut menu that opens 3 Type Custom Legend in the Object Name text box 4 Click OK 3 6 Customizing the Legende 33 Tutorial 3 Creating Multiple Layer Graphs Figure 3 10 The Final Graph Potential Pressure l Potential Pressure T i a gt 2 x Axia itle Y Axis Title 2 3 Axis Title 3 7 Saving the Graph as a Template Template files retain information on how to display the data but do not actually save the data The next time you need to create a similar graph you can select your worksheet data and then select your custom graph template Your custom template is easily accessed by clicking Template on the 2D Graphs toolbar To Save Your Graph as a Template 1 Right click on the graph window title bar 2 Select Save Template As from the shortcut menu that opens 3 Type Multilayer in the File Name text box 4 Click Save 34 e 3 7 Saving the Graph as a Template Tutorial 3 Creating Multiple Layer Graphs T
34. log Box i Limited mixing Cancel Color generatione by interpolation Range 4 Click OK 5 Click OK in the Plot Details dialog box 56 e 5 4 Customizing the Graph Tutorial 5 Creating 3D Surface Graphs Figure 5 7 The Customized Surface Graph tern 0 00030 0 00025 0 00020 0 00015 0 00010 0 00005 0 00000 I 004 In addition to editing color ranges you can edit individual colors This is especially useful if you have an important section of your data that you want to highlight or make transparent To Edit an Individual Color 1 Right click on the surface plot 2 Select Plot Details from the shortcut menu that opens 3 On the Color Map tab click on the color associated with 1 833E 4 5 4 Customizing the Graph e 57 Tutorial 5 Creating 3D Surface Graphs Figure 5 8 Selecting an Individual Color to Edit Fini ihe al Sy Graph LL Laai Cokr Map kureng Formats Side Wists Gode SutscevProection Click column headers lo edt enie columes chek ceb to edt individual pro p e Level Color Fill Comba Tees le Enabled Fist ala Moda Plt Typa aD Calomiap Stat Mates w Cacai So The Fill dialog box opens 4 Select None from the Fill Color drop down list then click OK 5 Click OK in the Plot Details dialog box The data plot redraws showing the transparent level Figure 5 9 Editing an Individual C
35. m Origin s analysis and fitting routines You can mask individual data points or a range of data Once data is masked options become available to change the masked data color hide or show the masked data swap the masked and unmasked data and enable or disable masking To Mask a Data Point in the Graph 1 Click Mask Point Toggle on the Mask toolbar This activates the Data Reader tool To open the Mask toolbar select View Toolbars select the Mask check box then click Close 2 5 Masking Data in the Graphe17 Tutorial 2 Exploring Your Data 2 Double click on the data point in the FLUOR data plot at X 34 Y 59 The data point becomes red and the point is masked Tip With the Data Reader open click on the FLUOR data plot then use the LEFT ARROW or RIGHT ARROW keys to read the XY coordinates on the Data Display tool Figure 2 7 Masking Data in the Graph Window Y1 Axis Title SIL Sly DA Data Display A Axis Title 3 Click Change Mask Color on the Mask toolbar The color changes to green 4 Click Hide Show Masked Points on the Mask toolbar to hide the masked data point 5 Click Hide Show Masked Points L on the Mask toolbar again to show the data point 18 e 2 5 Masking Data in the Graph Tutorial 2 Exploring Your Data 2 6 Performing a Linear Fit on the FLUOR Data Plot Now that a data point is masked in the FLUOR data plot subsequent analysis and fitting are performed
36. n text box 4 5 Fitting a Dataset Using Your Own Functione 41 Tutorial 4 Nonlinear Curve Fitting Figure 4 5 Defining a New Function NonLinear Curve Fitting Define New Function Miel E3 Function Action Options Scripts mer Type User Defined Number of Parameters E User Defined Param Hames Parameter Names Fi P2P3 Independent ar p Dependent War ly Example P1 smP2 cf File Form Expression Save Cancel Function formula user defined function description Basic Mode built in or external DLL function Basic Mode 6 Click Save The function is saved under the name MyFitFunc The MyFitFunc function will now be available in the list of functions under the currently active category The currently active category is the selected category In the NLSF Select Function dialog box Function Select from the NLSF menu Assigning the Function Variables to the Datasets The next step is to assign the X and Y variables in the function to the corresponding X and Y datasets in the data plot you are fitting To Assign the Function Variables to Datasets 1 Select Action Dataset from the NLSF menu bar 2 In the list box at the top of the fitter click on the Y variable in the list then click datal_b in the Available Datasets list box 42 e 4 5 Fitting a Dataset Using Your Own Function Tutorial 4 Nonlinear Curve Fitting 3 Click Assign Figure 4 6 Assigning Variable
37. n the Legends tab of the Plot Details dialog box select the Full Dataset Name check box 5 Click H next to the Graph 3 icon on the left side of the dialog box then select the Layer 1 icon from the graph tree 6 3 Customizing the Appearance of the Layout Pagee 69 Tutorial 6 Creating Presentations with the Layout Page 6 On the Display tab clear the Clip Data to Frame check box 7 Click OK 8 Drag the legend so that it displays within the axes of the graph then click in a blank section of the graph to de select the legend 9 Double click on the Layout icon on the right side of the Project Explorer to re activate this window The graph picture reflects your changes 6 4 Exporting the Layout Page In addition to customizing your layout page presentation in Origin you can export the layout page into other applications Origin provides a number of graphic export filters In addition you can copy the layout page to the Clipboard and paste it into other applications To Export the Layout Page as a Windows TIFF 1 Select File Export Page 2 Type Presentation in the File Name text box 3 Select Tag Image File TIF from the Save As Type drop down list Click Save The layout page is exported as a TIFF and can be inserted into any application that recognizes this file type 70 6 4 Exporting the Layout Page Tutorial 7 Working with Excel in Origin Tutorial 7 Working with Excel in Origin 7 1 In
38. ng 33 Linking layers 31 M Mask changing color 18 hiding showing 18 single data point 17 Matrix creating 52 plotting 53 setting dimensions 53 N NLSF advanced mode 39 assigning variables to datasets 42 basic mode 38 creating results worksheet 47 defining a function 41 fitting the data 46 initializing parameters 46 80 e Index iterations 47 naming new functions 41 opening 41 saving new functions 42 simulating curves 44 O Opening Excel workbooks 71 Layer n dialog box 26 NLSF 41 Plot Details dialog box 27 projects 23 P Plot Details dialog box 5 27 Color Map tab 55 Plotting Excel data 73 74 76 matrix data 53 ranges of worksheet data 15 17 worksheet data 3 Project Explorer hiding windows 24 viewing 24 Projects opening 23 saving 9 21 R Removing datasets from layers 48 Renaming the legend 33 Results creating NLSF worksheet 47 displaying 50 Results Log 50 Rotating 3D surface graphs 61 S Saving Excel workbooks 77 new fitting functions 42 projects 9 21 templates 34 Scale See Axes Index Select Data for Plotting dialog box 73 Selecting non consecutive columns 16 Set Levels dialog box 55 Setting column values 12 matrix dimension 53 worksheet display range 15 16 Sorting worksheet data 13 T Templates saving graphs as 34 Text adding to graphs 7 Text Control dialog box 7 Tools Enlarger 4 fitting 38 W Worksheets converting to matrices 52 creating XYZ 52
39. nsforming Column Values For more information You can create or transform datasets using any mathematical expression on the Set Column recognized by Origin in the Set Column Values dialog box This dialog Values dialog box see box provides a text box for you to type a value or mathematical Chapter 3 in the Origin expression to apply to the selected column or range of the column It also User s Manual includes a function drop down list from which you can select a function to add to the text box In addition a column drop down list contains a list of all the columns in the active worksheet Select the column you want to add to the text box then click Add Column to add the selected column to the text box To Transform the Column Values 1 Right click on the Depth Y column heading 2 Select Set Column Values from the shortcut menu that opens 3 Leave col A col B highlighted in the text box and select col DEPTH from the Add Column drop down list Click Add Column Col DEPTH overwrites the highlighted text 12 e 2 2 Transforming Column Values Tutorial 2 Exploring Your Data 5 Leave the cursor at the current location in the text box and type 3048 in the text box Figure 2 2 Transforming the Column Values Set Column Yalues For rows i j to 209 bslx abs Add Function bsolute value fcoDEPTH Add Column CollDERTHI colfDEPTH 3048 ala li Unido Lok Cancel 6 Cl
40. o test your template you can make the Layers worksheet active select all the worksheet columns and then click Template on the 2D Graphs toolbar Select MULTILAYER OTP then click Open 3 7 Saving the Graph as a Templatee 35 Tutorial 3 Creating Multiple Layer Graphs This page is left intentionally blank 36 e 3 7 Saving the Graph as a Template Tutorial 4 Nonlinear Curve Fitting Tutorial 4 Nonlinear Curve Fitting 4 1 Introduction Origin offers several methods of fitting functions to your data These methods vary in speed and complexity to optimize fitting for all users In this tutorial you will be introduced to fitting using the menu commands the tools and the nonlinear least squares fitter NLSF You will then define your own function and fit sample data using the advanced mode of the NLSF 4 2 Fitting from the Menu Origin offers access to several fitting functions directly from the Analysis menu To perform a fit on your data using the menu commands make sure that the data plot you want to perform the fit on is active then select the type of fit you want to perform from the Analysis menu Most of the menu commands require no parameter information from you and will carry out the fit automatically Some may ask you for some parameter information but will suggest default values based on your data Figure 4 1 Fitting Commands on the Graph Window Analysis Menu Fit Linear Fit Polynomial Fit Exponential Decay
41. of the software up to the number of licensed copies authorized If you have multiple licenses for the software then at any time you may have as many copies of the software in use as you have licenses The software is in use on a computer when it is loaded into the temporary memory 1 e RAM or installed into the permanent memory e g hard disk CD ROM or other storage device of that computer except that a copy installed on a network server for the sole purpose of distribution to other computers is not in use If the anticipated number of users of the software will exceed the number of applicable licenses then you must have a reasonable mechanism or process in place to ensure that the number of persons using the software concurrently does not exceed the number of licenses Technical Support Support hours are 8 30 A M to 6 00 P M EST Users must have their Origin serial number ready Users who have not yet registered with Microcal Software Inc should be prepared to register upon calling for technical support 1 800 969 7720 U S amp Canada Microcal Software Inc Tel 413 586 2013 One Roundhouse Plaza Fax 413 585 0126 Northampton MA 01060 tech microcal com USA Contents Contents Tutorial 1 Plotting Your Data 1 Wh TE OGG TOM aes satu 5 sane ae E A E E E A O A TE E E E E A AE A A S 1 W2 Epor ne rour Didascalie 1 1 3 Designating Worksheet Columns as Error Bars ea ai 2 IA Ptn YN onr Dillo 3
42. olor E Graphi 0 00030 0 00025 0 00020 0 00015 wn p 0 00010 F4 0 00005 0 00000 I 004 58 e 5 4 Customizing the Graph Tutorial 5 Creating 3D Surface Graphs Adding Contours to the Color Map Surface Graph To further enhance your graph you can display contour lines and colors on the top or bottom plane of your surface graph This is done on the Surface Projections tab of the Plot Details dialog box To Add Contour Colors to the Bottom Plane of the Surface Graph 1 Right click on the surface graph 2 Select Plot Details from the shortcut menu that opens 3 Select the Surface Projections tab 4 Select the Fill Color check box under the Bottom Contour text Figure 5 10 The Surface Projections Tab Fia eta Te Color Msp Murneno Formats Side Wale God Tudsce Pinjectione f Levert A Mana Guirao Too Gontaur Ballom Contour Fil Color z n E Gama F z r m om Lrayiah 05 JE JE 7 Gipping Levit fo High hoa of pen JR co een Plt Tipe JD Calomiap Seal 5 Click OK 5 4 Customizing the Graph e 59 Tutorial 5 Creating 3D Surface Graphs Figure 5 11 Displaying Bottom Contour Colors tern 0 00015 Wn p 0 00010 F4 0 00005 0 00000 I 004 With the current Z axis scale range and the current view angle the surface plot substantially overlaps the bottom contour blocking it from view To make more of the contour visible you can change
43. on S barvele day baovels day barrela day ba Domeshe crude al Crude sil produchon imports million rolben barrele dag bacrekidayl 89 rr 339 87h 603 D00 4a ooo a Spas i FO Li BI no f b k 7 3 Plotting an Excel Workbook in Origin There a number of ways to plot Excel workbook data in Origin These include but are not limited to using the Select Data for Plotting dialog box dragging data to a graph window and using Origins default plot assignments Creating a Graph Using the Select Data for Plotting Dialog Box The Select Data for Plotting dialog box lets you select data and then assign plotting designations 72 7 3 Plotting an Excel Workbook in Origin Tutorial 7 Working with Excel in Origin To Create a Graph Using the Select Data for Plotting Dialog Box 1 Click Column a on the 2D Graphs toolbar This opens the Select Data for Plotting dialog box 2 Reposition the dialog box so that you can see the column headings in the Excel workbook 3 Click the column A heading in the workbook then click in the Select Data for Plotting dialog box 4 Click the column C heading then CTRL click the column F heading and then click in the Select Data for Plotting dialog box Figure 7 2 The Select Data for Plotting Dialog Box Select Data for Plotting Book1 Sheet wi A En Label Title Row Flot i sc AT AES Tak oe F1 F65536 Z mo a Err
44. one 47 Tutorial 4 Nonlinear Curve Fitting 3 Click Close in the upper right corner of the NLSF to close the NLSF 4 Click Yes at the Attention prompt Figure 4 11 Final Graph with label repositioned and formatted bakas D AT AI_ del Ay FT Puro Chi AY DOS 0567 PARAMETER WALUEERRO A Pi 10 05 0 15G44 Pz 12508 20 1077 Fa ER Si n 2025641 After closing the NLSF a Parameters worksheet displays all the fitting results The graph window displays your data plot the simulated curves the fit curve and a text label with the parameter results To remove the simulated curves from the graph double click on the layer 1 icon then select the myfitfunc1_b myfitfunc2_b and myfitfunc3_b datasets in the Layer Contents list box and then click El Click OK to close the Layer 1 dialog box 48 e 4 5 Fitting a Dataset Using Your Own Function Tutorial 4 Nonlinear Curve Fitting The Results Log also displays the parameter results The Results Log is a dockable non editable text window The results from all the analysis and fitting done in a project are sent to the Results Log for viewing By default only the results from analysis performed in the active Project Explorer folder are shown in the Results Log To change the view mode right click in the Results Log and select the desired view mode from the shortcut menu that opens This shortcut menu also contains options for copying and clearing text from the Results Log
45. onlinear east Squares Belle eda i 38 WG Bane Modesti eee 38 Re ACV ANCEG Node west iero 39 4 5 Fitting a Dataset Using Your Own Function i 40 Openins the Project PING sario ee ii 40 Deimina Tane ON ceai a a T 41 Assigning the Function Variables to the DatasetS 42 Simulating Curves to Initialize the Parameter Values n 43 Panetier aa a a 46 Creating a Worksheet With the Fitting Results and Exiting the Fitter 47 Tutorial 5 Creating 3D Surface Graphs 51 VECOU ON masra a a seas Seataontseee a sncentdose 5I D2 Conyeru ti a W Ok SNC toa MIA 51 selectins the Type OF Conversioni Lillian IR 5S Crease OID SULT ACS Graphie a ilaria 53 5S4 Cust mizins he Graphic 54 Changing the Color Map Values 54 Changing the Color Map Colors 56 Adding Contours to the Color Map Surface Graph 59 Changing the Perspective of the Graph 61 Tutorial 6 Creating Presentations with the Layout Page 63 Gly Ti OCC COM ass acilia 63 6 2 Adding Graphs Worksheets and Text to the Layout Page cceececseeeceeeeeeneneees 63 Openins the PROJCC DENS tissiiss si cners iledeweiareindiocalaladevntatnedaussinndcocatisndaadactodtnstn niawesueeduecseelas 63 Creatine a New Layout Paseo agi ro 64 Adding Pictures and Text to a Layout Page 64 6 3 Customizing the Appearanc
46. only on the non masked data You can however disable the mask on the data point and analyze or fit all the data points in the current selection range To Perform a Linear Fit with the Data Point Masked 1 Select Analysis Fit Linear A fit line is added to the graph and the Results Log opens displaying the fitting results You can scroll the Results Log to view the results Click Refresh on the Standard toolbar and reposition the legend so it fits on the page Figure 2 8 Linear Fit of the FLUOR Data Plot with a Masked Data Point O FLUOR Linear Fit of TUTORIAL2 FLUOR Y1 Axis Title SUL SET GA A Axis Title 2 6 Performing a Linear Fit on the FLUOR Data Plote19 Tutorial 2 Exploring Your Data Figure 2 9 The Results Log Results Log mor E Faraneter Ualue EFFOF A 8 12658 0 11156 B 6 08723 6 86391 SD H A By default the Results Log shows the results for all fitting done in the currently active Project Explorer folder To change this default behavior right click in the Results Log and select a different viewing option Each time a new fit is done the results are appended to the Results Log Each entry in the Results Log includes a date time stamp the project file location the dataset the type of analysis performed and the results To Perform a Linear Fit with the Mask Disabled 1 Click Disable Enable Masking on the Mask toolbar The masked data point changes from green to black
47. or bars provided by the error bar columns to the right of the associated Y columns Figure 1 3 Plotting the Worksheet Data m Testi mv Test mV Al Test3 mv a k ite r gt x Axis Title Focusing on a Region of Your Graph You may want to take a closer look at interesting areas of your data particularly if you have a large number of points Origin provides a number of tools to accomplish this including the Enlarger tool The Enlarger tool automatically rescales the axes of the graph to show only the region of the data plot s you select 1 4 Plotting Your Data e 3 Tutorial 1 Plotting Your Data To Enlarge a Section of Your Data Click Enlarger on the Tools toolbar Click and drag with the magnifying glass cursor to draw a box around the large peaks near X 1 5 in the graph window Release the mouse button to complete the operation Figure 1 4 Enlarging a Section of Your Data Graph o E Testi my Test my zk Test my Y Axis Title E Tezi in Aa lesz iny ih Testa ny EAs Te 4 e 1 4 Plotting Your Data Tutorial 1 Plotting Your Data Note To return the axes to their original scale double click on the Enlarger tool 1 5 Customizing the Graph For more information on the Plot Details dialog box see Chapter 11 in the Origin User s Manual Origin allows you to customize every aspect of your gra
48. ph The easiest way to customize graphic elements is to double click on them Customizing the Data Plot Double clicking on a data plot or the data plot icon in the legend opens the Plot Details dialog box This dialog box allows you to customize the data plot you selected as well as all the features of the graph window except for the axes and text labels The selection on the left side of the dialog box determines the controls available for customizing on the right side of the dialog box For example when a line and symbol data plot is selected you can edit the attributes of the lines and symbols draw drop lines to either axis and select which features are incremented between the grouped data plots To Customize the Data Plot 1 Double click on the Test1 data plot icon in the legend The Plot Details dialog box opens with the TUTORIAL1 Time x Test1 Y data plot icon selected on the left side of the dialog box Select the Symbol tab if it is not currently selected Select the open circle symbol type O from the Preview drop down list Click OK Note Because the data plots are grouped the symbol type of the Test2 and Test3 data plots change to increment from the open circle symbol selected for the Test1 data plot 1 5 Customizing the Graphe 5 Tutorial 1 Plotting Your Data Customizing the Axes For more information Double clicking on any of the axes in the graph opens the Axis dialog on the Axis dialog box
49. rve Fitting Origin fits the data performing a maximum of 10 Levenberg Marquardt iterations The fit curve displays in the graph The chi squared value and the number of iterations performed are reported in the NLSF view box The updated parameter values are shown in the Value text boxes Figure 4 10 Fitting Session Function Action Options Scripts Parameter Value War Error F 10 05309 W 0 16644 0 62952 Pa 1 96338 W 010837 0 76662 FA 3 41 697 Wo 28641 0 6570 Dependency Press Esc key to stop fitting iterations Chi Square Chi sqr 6 490442 L eenzeee nie ne ana Levenberg M arquard Successtully progressed 4 rounds Chi sqr 0 0522 Total 4 rounds in this session Ea 10 Simplex Iter Done Chi Sqr 1 Iter I Perform a specified number of Levenberg M arquardt Basic Mode Iterations Press ESC to stop Creating a Worksheet With the Fitting Results and Exiting the Fitter After fitting your data you can create a worksheet that contains all the results of your fitting session Additionally when you close the fitter Origin displays the parameter fitting results in the Results Log and in a label in the graph window To Create a Worksheet with the Fitting Results 1 Select Action Results in the NLSF 2 Click Param Worksheet 4 5 Fitting a Dataset Using Your Own Functi
50. s to Datasets Zz 7 r ig mon ual n x LS aa i f on da i LI q io j ET di een SETO an E ri z x rE LI mes rar E casi Variable Datasets Fitting Range DATA B 1 14 sg Indep DATATA 1 14 Available Datasets Fitting Step Size a 1 lt How lt 14 a datal a Tel Shes Patameter sharing T Fit Multiple Datasets Sdi Wata Kemave Wata Assign the curent selected dataset to the current Basic Mode selected variable When you assign the Y variable to datal_b the Y dataset Origin automatically assigns the X variable to datal_a the associated X dataset Simulating Curves to Initialize the Parameter Values Origin lets you observe what the function will look like with various parameter values in the Simulate Curves dialog box This enables you to get an understanding of which parameter values produce curves that look similar to your data This 1s important because reasonably good starting parameter values are in most cases a precondition for the success of the fitting process 4 5 Fitting a Dataset Using Your Own Functione 43 Tutorial 4 Nonlinear Curve Fitting To Simulate Curves 1 Select Action Simulate from the NLSF menu bar 2 Type 5 in the PI P2 and P3 text boxes overwriting the dashes Figure 4 7 Simulate Curves Dialog Box Function Action Options Func Dataset Name MyFitFunc_B Dependent arables
51. the project When you save a workbook external to the project a link to the workbook is saved within the Origin project and the workbook can be opened and edited with Excel By default pre existing workbooks that are opened in an Origin project are saved external to the project whereas workbooks that are created from within Origin are saved internal to the project However the save option can be changed in the Workbook Properties dialog box To Save the Workbook Internal to the Origin Project 1 Make the Excel workbook active 2 Right click on the title bar of the workbook 3 Select Properties from the shortcut menu that opens 4 Select the Internal radio button in the Save As group of the Workbook Properties dialog box Figure 7 6 The Workbook Properties Dialog Box Workbook Properties Cancel File Name window Title Eook1 Linked File Path 7 4 Saving an Excel Workbook in Origine 77 Tutorial 7 Working with Excel in Origin Click OK Select File Save Project As Type Excel_Tutorial in the File Name text box Click Save The project is saved and the workbook is saved internal to the project Any changes that you now make to the Excel workbook located in the TUTORIAL folder will not be reflected in the project file the next time it is opened 78 e 7 4 Saving an Excel Workbook in Origin Index 3 3D surface graphs adding contours 59 changing colormap levels 54 creating 53 rot
52. ting non associated columns with CTRL selection the default plotting behavior allows you to quickly create graphs from associated XY datasets To Designate a Second X Column 1 Double click on the Layers worksheet icon on the right pane of the Project Explorer 2 Right click on the Trial2 column heading in the Layers worksheet 3 Select Set As X from the shortcut menu that opens The Trial2 column designation changes to X2 and the columns to the right of it are designated as Y2 In addition the Triall column designation changes to X1 and the columns between Triall and Trial2 are designated as YI This allows you to quickly determine which column will be providing the X values for the data you are plotting 3 5 Creating a Multiple Layer Graph Origin cannot possibly contain pre defined templates for all the different ways in which layers can be arranged so it lets you to create your own 3 4 Designating Multiple X Columns in the Worksheete 25 Tutorial 3 Creating Multiple Layer Graphs custom multiple layer graphs Once you have created a graph you can save it as a template and then plot to it without having to re build the same graph every time To Create a Multiple Layer Graph 1 Click on the Potential column heading to highlight the column 2 Click Line on the 2D Graphs toolbar Figure 3 2 Line Graph of Potentiall Column Frama 3 Select Tools Layer to open the Layer tool 4 With the Add tab sele
53. tions X Y Err Y Err Y Err To Designate Columns as Error Bars 1 Click on the Time X column heading and drag to the Error3 Y column heading 2 Right click within the highlighted cells to open a shortcut menu 3 Select Set As X Y Err Y Err from the shortcut menu This changes the Error1 Error2 and Error3 columns to error bar columns Figure 1 2 Changing Worksheet Column Designations 88 TUTORIALI Time E Error isat pa CENE miii 1 021 4 309E di 2 1 baE 0 038 4 393E 4 Z 196E 6 0 064 4 309E 4 2 7 666 5 D 0f1 4 362E 4 2 1B7E 5 5 106E 2 563E 5 3 079E d 1 b36E b wa ASE PES IMEE 2 e 1 3 Designating Worksheet Columns as Error Bars Tutorial 1 Plotting Your Data 1 4 Plotting Your Data Origin offers a broad range of plotting options The quickest way to create a graph is to select your worksheet data by highlighting the column s and then clicking a graph button on one of the graphing toolbars When you plot multiple columns using this technique Origin automatically groups the data plots and increments attributes such as the symbol type and color so that you can easily distinguish between data plots For more information on grouped data plots see Chapter 11 in the Origin User s Manual To Plot Your Worksheet Data 1 With your worksheet data still selected click Line Symbol on the 2D Graphs toolbar The three Y columns are plotted as line and symbol data plots with err
54. troduction Origin provides you with the ability to open Excel workbooks from within Origin provided you have Excel 7 or later installed on your computer This allows you to combine Excel s spreadsheet functionality with Origin s powerful graphing and analysis tools This tutorial will introduce you to opening an Excel workbook in Origin and plotting the workbook data and saving workbooks from within Origin 7 2 Opening an Excel Workbook in Origin Note To perform this tutorial you must have Excel version 7 or later installed on your computer either as a local or network copy In addition this tutorial assumes the default settings are selected on the Excel tab of the Options dialog box Tools Options To Open a Previously Created Excel Workbook 1 Click New Project on the Standard toolbar 2 Click Open Excel on the Standard toolbar 3 In the Origin 6 0 TUTORIAL folder select TUTORIAL_7 XLS from the list of files 7 1 Introduction e 71 Tutorial 7 Working with Excel in Origin 4 Click Open 5 Select the Open As Excel Workbook radio button in the Open Excel dialog box then click OK The workbook opens in the Origin workspace In addition a combination of Origin and Excel menus and toolbars are now displayed in the workspace Figure 7 1 Opening an Excel Workbook in Origin al Danki Dein BOT tho T ut ioe il Fads Petroleum products Crude al Laporte Total imperts exports million albon mili
55. ts of one worksheet and one graph window and the data displayed in both Both of these windows and the data they contain are saved within an Origin project file when you save the project To Save Your Project 1 Click Save on the Standard toolbar 2 Type Tutorial_1 in the File Name text box then click Save The project is saved as Tutorial_1 OPI 1 6 Saving Your Project e 9 Tutorial 1 Plotting Your Data This page is left intentionally blank 10 e 1 6 Saving Your Project Tutorial 2 Exploring Your Data Tutorial 2 Exploring Your Data 2 1 Introduction This tutorial will show you how to mathematically transform data in a worksheet column sort a worksheet based on primary and secondary columns plot a range of worksheet data and mask data from analysis routines To begin this tutorial you will open a new Origin project and import ASCII data To Import the Data File 1 Click New Project on the Standard toolbar iti 2 Click Import ASCII then select TUTORIAL 2 DAT from the Origin 6 0 TUTORIAL folder 3 Click Open 2 1 Introduction 11 Tutorial 2 Exploring Your Data Figure 2 1 Importing the ASCII File 88 TUTORIAL2 p45 BT s e Note There are several columns that are not visible due to the current worksheet size When there is a reference in this tutorial to a column that is not visible use the horizontal scroll bar on the bottom of the worksheet to locate it 2 2 Tra
56. values to select a range then click on the Level or Fill column heading To Change the Number of Levels in the Color Map 1 Right click on the surface plot 54 e 5 4 Customizing the Graph 2 Select Plot Details from the shortcut menu that opens Tutorial 5 Creating 3D Surface Graphs 3 Click on the Level column heading to open the Set Levels dialog box 4 Select the Num of Levels radio button then type 12 in the associated text box Figure 5 4 The Set Levels Dialog Box Set Levels Minimum 52005 Masimu 0 0003 Cancel C Interval 4 3756 005 Find Min Max f Mum of Levels fiz Log Scale 5 Click OK The Color Map tab updates to show twelve levels plus levels for values above and below the maximum and minimum levels and associated colors in the list box Figure 5 5 Updated Color Map Tab Fiat Detail Sy Graph Color Map Hurio Formats Side Walls Gide Sufsce Praischone a L Laai Chek c na headers to edt entire columia chek cel to edt LA Maril individual pra petti Plot Typa ab Catornap Sia asl batta DE Cantal Appi 5 4 Customizing the Graph e 55 Tutorial 5 Creating 3D Surface Graphs Changing the Color Map Colors Customizing the Fill Color Range 1 Click on the Fill column heading to open the Fill dialog box 2 Select Red from the From drop down list 3 Select Green from the To drop down list Figure 5 6 Editing the Fill Dia
57. yer Graph e 31 Tutorial 3 Creating Multiple Layer Graphs Figure 3 9 Adding Data to the Top Layers a we L Potentiali tmi X Axise Title Y Axis Title x Axis Title You can test the axis link by double clicking on the bottom X axis and changing the From or To values on the Scale tab After clicking OK the top X axis also reflects your changes 3 6 Customizing the Legend By default Origin creates layer specific legends You can however alter this default behavior and display the data from all the layers in one legend Origin uses the embedded text formatting switch L to draw the data plot type representations in the legend To display the correct data plot type representations from different layers you must specify the layer number followed by a period then the number of the data plot in that layer To Customize the Legend 1 Clickon the text portion of the legend for the bottom layer reading Potentiall mV then press DELETE 2 Double click on the text portion of the legend for the top layer reading Potential2 mV 32 e 3 6 Customizing the Legend Tutorial 3 Creating Multiple Layer Graphs 3 In the Text Control dialog box type the following text overwriting L 1 1 L 1 1 Potentiall L 2 1 Pressurel L 3 1 Potential2 L 4 1 Pressure2 The preview box on the bottom of the dialog box shows what the text will look like in the legend Click OK Drag the legend to a
Download Pdf Manuals
Related Search