OriginLab Corporation - Data Analysis and Graphing Software - 2D graphs, 3D graphs, Contour Plots, Statistical Charts, Data Exploration, Statistics, Curve Fitting, Signal Processing, and Peak Analysis     
 
Skip Navigation Links
All BooksExpand All Books
User GuideExpand User Guide

13 Graphical Exploration of Data



Grand image graphical exploration 3c.png

Origin includes a number of tools for graphically exploring your data, including tools for magnifying and zooming, reading XY coordinate values, and drawing and deleting data points.

Origin 2016 introduced add-on tools called Apps. Since being introduced, many new exploratory and analysis-related tools have been added to OriginLab's File Exchange and more tools are being released all the time. Please visit the File Exchange to review available tools.

Zooming, Panning and Rescaling

This section discusses the use of toolbar tools, and keyboard and menu commands that change the view of the graph. We have split these tools and commands into two groups: Page-level zoom and panning operations that do not change axis scales; and Rescale operations which zoom and pan the graph by changing axis From and To values.

Note: Page level zoom and panning treat the graph page as a whole. You can read the current zoom level in the Zoom dropdown list of the Standard toolbar. Page level zoom and pan will not affect the printout or export of the graph, while Rescaling changes axis scales and will affect the printout and export of the graph.

Page Zoom and Pan

Action Button Shortcut Key Menu Notes
Zoom-Panning: Zoom and pan the graph page. Button Panning.png -- --
  • Use mouse wheel to zoom in or out, with "hand" as focal point.
  • Drag with left mouse button to pan.
Whole Page: Show the whole graph page. Button Whole Page.png CTRL + W
View: Whole Page
  • Reset the view of the page after using the Zoom-Panning tool.
Zoom All: All objects in the window are shown. -- -- View: Zoom All
  • Can be used to locate "lost" objects lying outside the graph page.

Axis Rescaling

Action Button Shortcut Key Menu Notes
Rescale: Rescale and pan the graph in both X and Y dimensions. Button Rescale Tool.png -- --
  • Scroll to rescale X.
  • SHIFT + scroll to rescale Y.
  • Drag with the left mouse button to pan (also rescales).
  • Rescales both X and Y.
Rescale the graph in the X dimension. -- Z + scroll wheel

or
Z + +/- keys

--
  • Rescales X.
  • Does not rescale Y.
Pan the graph in the X dimension. -- X + scroll wheel

or
X + +/- keys

--
  • Rescales X.
  • Does not rescale Y.
Rescale the graph in the Y dimension. -- SHIFT + Z + scroll wheel

or
SHIFT + Z + +/- keys

--
  • Rescales Y.
  • Does not rescale X.
Pan the graph in the Y dimension. -- SHIFT + X + scroll wheel

or
SHIFT + X + +/- keys

--
  • Rescales Y.
  • Does not rescale X.
Scale In/Scale Out: Rescale the graph in X and Y dimensions. Button Scale In.png -- --
  • Select Scale In button, then drag out a rectangle to define axis scale range.
  • Reset by clicking on the Scale Out button (no need to drag).
  • Rescales both X and Y.

Origin 2017 introduces several modified or new Graph toolbar buttons for separate or "all together" axis rescaling.

  • The Rescale X Button Rescale X.png button changes the X axis scale to show all X values within the limits of existing Y/Z axis scales.
  • The Rescale Y Button Rescale Y.png button changes the Y axis scale to show all Y values within the limits of existing X/Z axis scales.
  • The Rescale Z Button Rescale Z.png button changes the Z axis scale to show all Z values within the limits of existing X/Y axis scales.
  • The Rescale XY Button Rescale XY.png button changes X and Y scales to show all X/Y values (within scale limits of any existing Z axis).
  • The Rescale (All) Button Rescale All.png button changes all axis scale ranges and displays all data in the layer.

Note that some of these buttons may be turned off by default. To add or remove buttons from a toolbar, see The Customize Toolbar Dialog Box.

Origin 9.1 SR0 introduced the @nrm system variable to modify rescale behavior when using the Rescale tool or associated shortcut keys:

@nrm = 0: From/To values on the Scale tab of the Axis dialog box will change when Rescale is set to Manual. This is established behavior.

@nrm = 1: From/To values will not change when Rescale is set to Manual. This is new behavior.

Modify the current behavior by opening the Script Window (Window: Script Window), typing @nrm = <value>, then pressing ENTER.

Note:When using the older Scale In tool you are prompted to override Manual rescaling. However, when @nrm=1 you cannot override the Axis dialog box Rescale setting.

Reading Coordinate Values

Origin provides several tools to aid in graphical exploration of your data plots. Most of these tools are available from the Tools toolbar (View: Toolbars). There is a related tool -- Vertical Cursor -- available from the Gadgets menu.

The simplest data exploration tool is the Screen Reader Button Screen Reader.png. The Screen Reader works with the Data Display window to dynamically display the XY coordinates of the cursor on the graph page. The Data Display window opens automatically when you select the Screen Reader tool from the Tools toolbar.

The Data Display Tool-1.png


You can alter basic properties of the Data Display window by right-clicking on the window title bar or by right-clicking inside the window.

To use the Screen Reader:

  1. Click the Screen Reader button Button Screen Reader.png on the Tools toolbar. This opens the Data Display tool.
  2. Click on a location in the graph page to read its X,Y, and Z coordinates (ternary and contour only). Coordinate values show in the Data Display tool.
  3. To increase cross-hair size, press the space bar.
  4. Click the Pointer button Button Pointer.png on the Tools toolbar to exit screen reading mode.

You can hover on a data plot to see the source book, sheet and dataset.

Source data on hover.png
Dataset information is hyperlinked; simply click on a dataset to open the source sheet.

The Data Info Window

The Data Info window opens when you choose either the Data Reader Button Data Reader.png, the Annotation Button Data Annotation.png or the Data Cursor tools Button Data Cursor.png. At first glance, the Data Info window seems to duplicate the functionality of the Data Display tool (reading XY coordinates in the graph).

DataInfo window.png

However, the Data Info window is customizable and ultimately, more powerful than the Data Display window. In addition to numerical data, you can display other classes of data -- metadata and images -- associated with a particular data point.

DataInfo window customized.png


To customize the display of the Data Info window, right-click on the Data Info window and choose Preferences... from the shortcut menu. Use the controls in the Data Info Report Settings dialog box to customize the display of the Data Info window:

DataInfo Report Settings.png

  • The Title tab is used to specify how the report title is displayed in the upper left corner of the Data Info window.
  • The Rows tab is used to specify which columns in the data worksheet are shown in the Data Info window.
  • The Columns tab allows control over what displays in the Data Info window. In addition to the data groups that are chosen in the Rows tab, the user can choose to show additional information such as the Long Name, Short Name, Units, and data contained in individual cells.
  • The Display tab contains options for customizing the display properties of the Data Info window.
  • On the top of the dialog, there is Dialog Theme control. The Data Info. window customization can be saved to graph, layer and even plot level so that every time you use Data Reader, Cursor, or Annotation tool on such graph, layer or plot,such Data Info. window will show up. Or you can save it as a theme file and load it in the future.

The Data Reader Tool

Use the Data Reader tool to read information associated with a data point in your plot. This information can include XY(Z) coordinate values and other metadata and images describing the data point.

The Data Reader Button Data Reader.png tool is grouped with two related tools -- an Annotation Button Data Annotation.png tool and a Cursor Button Data Cursor.png tool. Only one of these will display at a time. To select a hidden tool, click on the small arrow in the lower-right corner of the button and select a tool from the shortcut menu.

To use the Data Reader tool:

  1. Click the Data Reader Button Data Reader.png button on the Tools toolbar. This opens the Data Info window.
  2. Click on a data point to read its X,Y (and Z, if they exist) coordinates. Coordinate values display in the Data Info window (and Data Display window).
  3. To move the cross-hair to the next data point along the data plot, use the LEFT and RIGHT arrow keys or click on the data point using your mouse. If you have multiple plots in a layer, use UP and DOWN arrow keys to move it to a data point on another plot or user mouse to click it.
  4. To change the vertical and horizontal cross hair size, click on a point and press the spacebar to adjust.
  5. Click the Pointer button Button Pointer.png on the Tools toolbar to exit the Data Reader tool.

The Annotation Tool

Use the Annotation tool to label a data point. The tool works with most Line + Symbol and Column/Bar plots. Choose from several standard data point labels or create your own custom label using LabTalk script.

The Annotation tool has been improved for 2017. A new Annotation dialog offers more flexible label and leader line customization, plus positioning and programming controls. Also, you can now ALT + drag a label to another data point and the label will automatically read the new data point.

To annotate a data point:

  1. Click the Annotation button Button Data Annotation.png on the Tools toolbar and move the cursor to your graph. Note that the cursor and the Status Bar display the label form.
  2. StatusBar Annotation Message.png
  3. Use the TAB to toggle between the following standard annotation options: (X coordinate value, Y coordinate value), (X coordinate value, Y coordinate value)[index number], X coordinate value, Y coordinate value, or index number (row number), or Custom (see Tutorial, next).
  4. Double-click to add the chosen label to the data point.

Tutorial: Customizing the Annotation String

The annotation string can be customized by combining literal characters with the X and Y coordinate values:

  1. Start with a graph of your data
  2. Open the Script Window (Window:Script Window) and type the following command, then press Enter:
system.annotation.customlabel$="X value: $(x,.2), Y value: $(y,*5)"
  1. Click the Annotation button Button Data Annotation.png, hover on your graph, then press the Tab key several times to cycle through the annotation choices until the custom string format specified above is displayed in the status bar. The cursor will display the word "Custom".
  2. Start double-clicking on data points to add the custom annotation string. The X values will be displayed with two decimal places and the Y values will be displayed with 5 significant digits.
Note: Please view more information on string formatting in the Programming help file:

Help: Programming: LabTalk > Language Reference > Object Reference > Alphabetical Listing of Objects > String

Switch to the Pointer Button Pointer.png and drag to re-position overlapping labels. A leader line is automatically added.

The Data Cursor Tool

The Data Cursor tool allows you to place cursors on a data plot and then measure the X and Y distance between the cursor locations. The cursors can also be placed on different data plots within a layer to measure relative distance between data points in different plots. Data cursor work together with data reader to read X and Y distance between data reader and data cursor.

Tutorial: Using the Cursor Tool to Measure Relative Distance

  1. Import the file Samples\Spectroscopy\Sample Pulses.dat and create a line plot.
  2. Click and select the Data Cursor button from the Tools toolbar.
    Cursor-Relative-1.png
  3. Double-click on one of the peaks or click once on a data point and press ENTER, to add a cursor object.
    Cursor-Relative-2.png
  4. Repeat to place a second cursor object on another peak.
  5. Double click in Data Info. window to open Data Info. Report Settings dialog. If this window is not visible, select the View: Show Data Info menu item to open the Data Info. window.
  6. Switch to the Columns tab and then right-click in the gray area to the right of the columns and choose Add Column.
  7. In the new column that is added, click on the source row of new column, and select Relative (Cursor2 - Cursor1) from the drop-down, and then press OK to close the dialog.
  8. Now you can drag and move the cursor objects and the third column in the Data Info window will display the X and Y distances between the two cursors.


Cursor-Relative.png

Gadgets

Origin provides several Gadgets for data exploration and analysis. These gadgets are accessible from the Gadgets menu when a graph window is active. Three gadgets in particular are suitable for data exploration:

The Vertical Cursor gadget is especially useful for reading XY coordinate values for data points in stacked panel plots or multi-plot graphs, where plots share a common X scale.

To open the Vertical Cursor:

  1. With a graph window active, choose Gadgets: Vertical Cursor... from the main menu. This opens the Vertical Cursor dialog box.

Using the controls in this Gadget's dialog box, you can add data labels to the graph, increase or decrease label font size, hide labels, etc.


Vertical Cursor 01.png

The Statistics gadget returns basic statistics on data points falling inside a rectangular region-of-interest (ROI) on the graph.

  • Display basic statistics for data inside the ROI.
  • Display mean and nth Standard Deviation lines inside the ROI.
  • Update results dynamically as ROI is moved or resized.


Statistics Gadget.png

The Cluster gadget (available in OriginPro) provides the following features:

  • Display basic statistics for data inside a region of interest (ROI).
  • Switch between rectangular or elliptical ROI.
  • View statistics for points inside and outside of the ROI.
  • Edit, copy, mask, delete or group data points.
  • Update results dynamically as ROI is moved/re-sized.
  • Output results to a worksheet.


Cluster Gadget.png

Note: To learn more about these gadgets, see:

Help: Origin: Origin Help > Gadgets

Topics for Further Reading

 

© OriginLab Corporation. All rights reserved.