Quick Overview of Data Import in Origin 2016 Video Lecture | Origin Tutorials for Beginners - Data & Analytics

importing data into origin is very easy
with drag-and-drop support available for
many standard formats for example here
we have an excel file we'd like to
import after the data is brought in you
can right click the headers and set them
as comments
name
or units
in addition to drag and drop you can
also use the import dialog to bring in
data with more advanced options
let's prompt this dialogue by clicking
the import Excel button after selecting
our file we can tell origin which sheets
to import in this case there's only one
in the column headers tab you can also
specify how many rows of data cover the
main header and sub header and set them
as the long name and units and we can
also turn on sparklines to easily view
trends in our data now that our data is
imported let's make some modifications
first we'll add a new column for
corrected data which will calculate by
subtracting the blank data from our
sample data you can use the f of X row
to enter any formula with origin
scripting language lab talk once the
formula has been entered a green lock
icon will appear in the header to
indicate the values of this column or
the output of an operation you can also
turn on the sparkline of newly added
data by using the option in the
right-click menu
now let's generate a double-wide
of the sample data and corrected data if
we want to include our graph with our
data we can add it as a floating graph
in the same worksheet
now let's say our Excel file changes
here we've pasted some new data in the
sample column and saved it in origin we
can easily update our workbook in
corresponding graph by going to file re
import directly
you can see the corrected column updates
automatically and our graph reflects
this the XE scales however will not
update because the axis rescale mode is
set to normal by default you can open
and further customize a floating graph
simply by double clicking on it
now that our graph is open let's double
click on an axis to open the axis dialog
let's set both the X and y-axis rescale
mode to auto once we've done this will
hit rescale to see the effect this has
and repeat these steps for the axis on
our second layer
we'll click return to go back to the
worksheet now that everything is set up
in one workbook if you want to import
more data and we produce the same
calculation and graph just click the
import Excel button a second time select
some more data files and in the import
dialog set the first file import mode
and multi file import mode to start new
books because this data is organized the
same way as a previously imported data
we'll set our template to clone with
this setting origin will clone the
active workbook and then import our new
data therefore the new data will be
handled in the same way as the previous
data set with Collin calculations and
the double Y graph updated accordingly