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

Introduction

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:

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.

Example

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:

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:

The generated graph looks like this:

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:

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:

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.

Related Posts

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”

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. snow says:

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