Plotting Horizontally Arranged Data Using Row-Wise Plotting in Origin 2019


When plotting XY type data, Origin typically expects that the  X and Y datasets be in columnar form. Multiple Y datasets with a shared X column would, of course, occupy multiple Y columns.

But sometimes we have customers whose XY data is horizontally arranged where the X dataset occupies one row and the Y dataset occupies another. Given a shared X  dataset, multiple Y datasets would occupy multiple rows.  We can refer to this as row-wise data. For example:

Columnar vs row-wise data.
A simple example of the same XYY datasets presented in columnar format versus row-wise format

Starting with Origin 2019, Origin is able to plot this row-wise data without first  converting it to columnar data. We call it Row-wise Plotting and it is available from the Plot menu.


Let’s show an example of creating a Row-wise Plot from row-wise data.

If you wish to follow along or view the  finished example (and other examples) for yourself, you can  download the Origin Project. In the project, each graph associated with the relevant workbook is embedded into a worksheet entitled “Graph”. Double-click on the embedded graph to activate it. You can also click on the green lock icon and select Change Parameters… to see the settings used to create the graph.

The row-wise data in this example contains an X dataset that represents numeric percentages in the Long Name label row and looks like:

Example 1: Row-wise data with X dataset in Long Name label row.

To create a Row-wise Plot from this data:

  1. Select the rows of data.
  2. From the Plot menu, click on the Row-wise… icon.
  3. In the Row-wise Plot: plot_rowwise dialog, set:
    • Y Label In: A(X) : Component Percent
    • X Data in: Column Label
    • Column Label: Long Name
    • Plot Type: Line + Symbol
  4. Unless Auto Preview is checked, click the Preview button to see a preview of the graph.
  5. Click OK to generate the graph.

Note: You may observe a new worksheet has been added to the workbook. This sheet is automatically generated during the processing of creating the graph.

This animated GIF illustrates the process:

Illustration of the steps in Example 1
Illustration of the steps in Example 1.

The generated graph looks like this:

Generated Row-wise Plot graph
Example 1: Generated Row-wise Plot graph.

You will observe that the X axis tick labels have been converted to percent labels. This is possible because Origin recognizes that the X data in the Long Name row is numeric. In the Axis Dialog, the Tick Labels: Display is set to Custom and Custom Format set to #%.

A Note about format of X data

Origin 2019 is smart about handling of non purely numeric data in column labels rows. It can handle data time values and, as illustrated below, Origin is able to extract the numeric part of the percent value and set plot labels to the numeric values:

Example 2: Origin 2019 smartly parses numeric values from column label rows and plots them as numeric labels.
More Options for X Data

There are more options in the X Data in dropdown control in the dialog for specifying the location of the X dataset:

  • First row in Row-wise Data: When selecting rows to plot, use the first selected row for the X dataset.
  • First row in sheet: Use the very first row in the worksheet for the X dataset.
  • Custom: Use the Hunt button to select an arbitrary row for the X dataset.
Row-wise Y Errors

Row-wise Plots also support Y errors and will automatically include the error bars when generating the graph. Simply structure your Y and Y Error datasets as illustrated below:

Y and Y Error for dataset structure.
Illustration of Y and Y Error dataset structure for Row-wise Plotting data.
Adding More Data Later?

If you think you will be adding more rows of data at a later time, a good hint is to over-select the rows when creating the plot. For example, if you select an additional 5 empty rows after the data ends, you will be able to add up to five more rows later and they will use automatically incorporated into the plot graph.

About Chris Drozdowski

Chris Drozdowski is a Product Support Engineer at OriginLab. He loves to talk to customers and educate them. He particularly relishes diagnosing and solving difficult, edge-case issues. As well, he contributes code to help solve problems or enhance user experience. In his down time at work, he likes to research and write about esoteric product features. Outside of work, he enjoys spending time with his family, having fun with C++, working on his aquarium, and exploring craft beers.

View all posts by Chris Drozdowski →

2 Comments on “Plotting Horizontally Arranged Data Using Row-Wise Plotting in Origin 2019”

  1. Hi Chris,

    I am new to orgin pro. I am still giving it a try with trail version. I have difficulties plot reaction norms. I tried using the row wise plot and I can make reaction norms but they plot each replicates separate. Please see the attached example of my data sheet. I have two locations, and two genotypes and valules for RWC. I want site as X axis and average of RWC for each genotype and Y lable should display the two genotype names.
    Hope to get some advice from you.

    Site Genotype RWC
    BFL ARA 10
    BFL ARA 14
    BFL ATA 15
    BFL ATA 20
    KING ARA 21
    KING ARA 25
    KING ATA 30
    KING ATA 34

    1. Hi Bhaskar,

      I think you want to plot a 2×2 trellis plot with mean showing in each panel. We don’t support showing statistics directly in trellis plot but

      here are some simple steps to achieve what you want in Origin 2019. Note: It’s not supported in 2018 or lower versions.

      1. Highlight column RWC and choose Plot: Box Chart: Interval Plot. It will just treat all RWC and plot the mean+95% CI
      2. Double click the box to open Plot Details dialog.
      3. Go to Panel tab. Enable Horizontal panel. Choose By Columns and click the > button to add Column (Site)
      4. Enable Vertical Panel. Choose By Columns and click > to add Column Genotype.
      5. Click OK.
      6. You can click Ctrl+R to rescale the graph.
      7. If you only want to see Mean, don’t want to see the 95% CI, double click the plot. Go to Box tab. Set Whisker -> Range as None.

      Thanks, Snow

Leave a Reply

Your email address will not be published. Required fields are marked *