The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Plotting a double y-axis graph with 3 data groups
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Clianthus

New Zealand
8 Posts

Posted - 11/04/2013 :  2:56:20 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): 8.5.0 SR1
Operating System: Windows 7

Hi,
I need to plot three groups of data (the dose response of 3 insect species ) onto a double y axis graph, as columns with standard error bars.

I have tried various tutorials that I have found for older versions of Origin, but I can't seem to plot it correctly in 8.5.

Does anyone have suggestions or can point me in the right direction of a correct tutorial?

Thanks in advance!

Hideo Fujii

USA
1582 Posts

Posted - 11/04/2013 :  5:27:50 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Clianthus,

The typical procedure to create a double-Y graph with more than tow datasets is:

1) Prepare a worksheet which contains your X-Y-YErr triplet columns, which are arranged in such column order, and designated as they are (X-Y-YErr-X-Y-YErr-... when each triplet has own X, or X-Y-YErr-Y-YErr-... when X are common).

2) Make a double-Y plot from the first two triplets. It contains two layers, namely Layer1 and Layer2.

3) For the 3rd (or later) triplet, determine which Y axis scale (Layer1 or Layer2) the new triplet plot should belong.

4) Say, the 3rd plot should belong to Layer2 within its Y scale, double-click the layer icon of Layer2 (small grey square [2] at the top left corner) to show the Layer Contents dialog box.

5) In this dialog, choose both Y column and YErr columns of the 3rd triplet in the left box, and press "=>" button to move them to the right box. Click OK.

6) If you have further triplets, repeat 3)-5) for each.


Regarding the Layer Contents dialog, see the following video/instructional tutorials:
http://www.originlab.com/index.aspx?go=Products/Origin/Graphing&pid=1748
http://wikis/howto/index.php?title=Tutorial%3AAdding_Plot

Hope this helps you.

--Hideo Fujii
OriginLab

Edited by - Hideo Fujii on 11/04/2013 5:31:39 PM
Go to Top of Page

Clianthus

New Zealand
8 Posts

Posted - 11/04/2013 :  9:06:35 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Hideo,

Thank you so much for your help. Your instructions worked perfectly! I now have the following line graph. How can I turn it into a column graph? I tried using the column icon, and also by selecting each layer and choosing column in the plot setup, but both ways make the graph look messy and will not change all the lines to columns.

How can I change to columns and have 3 bars for each time point (0,2,7,0,2,7 days)?

Also, why did the legend not update when I added the third plot? It is named in the worksheet.

Sorry for all the questions! Thank you!

http://www.originlab.com/ftp/forum_and_kbase/Images/2 Y axis.ogg
Go to Top of Page

Clianthus

New Zealand
8 Posts

Posted - 11/04/2013 :  9:12:54 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Sorry! I didn't insert it correctly the first time

Go to Top of Page

Echo_Chu

China
Posts

Posted - 11/04/2013 :  10:55:27 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply

Hi Clianthus,

I am wondering why you need a second Y axis. Do you have two datasets in layer2 which are similar scale? Would you mind sending us your data/opj then we can try to create the plot with your data.

You could follow the instructions below to send your file.
http://www.originlab.com/index.aspx?go=Support&pid=752

Echo
OriginLab Corp,
Go to Top of Page

easwar

USA
1964 Posts

Posted - 11/05/2013 :  10:41:11 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Clianthus,

Grouped column and box plots are now supported in the latest version, 9.1

I made the following plot with 9.1 with your data (roughly digitized, added arbitrary numbers for error bars):


I plotted the first two datasets as a double-y plot, and then changed the plot type from line to column/bar. Then I added the third dataset to the 2nd layer.

Then in Plot Details dialog, at the Graph level, in the Miscellaneous tab, I checked "Column/Bar Gap/Offset Across Layers", this check box is also available in 9.0

In 9.1, one can add tick label tables above/below the plot, and so in this graph I added a table with two rows, and set them to show the treatment type and days after treatment information.

You can download the 9.1 demo and try. Here is more info on grouped column/bar plots in 9.1:
http://www.originlab.com/index.aspx?go=Products/Origin/91/ColBarPlot

When you add a new data plot to a layer, just do CTRL-L to refresh the legend, or right-click on the legend to see context menu with more options.


Easwar
OriginLab
Go to Top of Page

Clianthus

New Zealand
8 Posts

Posted - 11/26/2013 :  5:20:44 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Apologies for the delay of my reply!

I.T. upgraded me to Origin 9.1 and I was able to easily create the graph I required. The person who wanted the graph preferred it without the table.

Thank you so much for all the help!
Go to Top of Page

magicalmarshmallow

10 Posts

Posted - 04/02/2014 :  09:03:44 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hey,

I have followed the instructions here and it works brilliantly, so thank y'all!
My data is not all positive, so for my purpose, I want to have the X-axis cross at '0' on both the left and right axes. I can put it at the bottom, but the bars are then quite ambiguous.
At the moment, the best I cna do is 0 on the right axis & -1750 on the right.

Surely there's a solution that I can't see

Please and thanks

Go to Top of Page

lkb0221

China
497 Posts

Posted - 04/03/2014 :  11:40:52 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

In axis dialog, X Axis: Gird node, check Y=0 checkbox and apply.
You would need to do this for both layers.
Control your axis scale and tick to make both 0 in the same position.
For example:


Zheng
OriginLab
Go to Top of Page

magicalmarshmallow

10 Posts

Posted - 04/04/2014 :  06:57:50 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Zheng,

I've tried what you've said, but no joy. Checking the y=0 box has no effect, not does CTRL+R

Could this be to do with the fact that the 2nd layer X-axis isn't present?

Have I missed something?
Go to Top of Page

lkb0221

China
497 Posts

Posted - 04/04/2014 :  09:53:06 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

I don't think whether the X in 2rd layer is present matters.
Can I have your email address? Let me make a sample opj for you so you can play around.

Zheng
OriginLab
Go to Top of Page

SusanaP

Portugal
1 Posts

Posted - 04/28/2014 :  7:18:00 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hello,

The instructions are really good and help a lot. However, when I try to add a 2nd Y axis the error bars already on the graphic in the 1st Y axis move away from the column. In the end I have columns with the correct error bar and others with the error bar away (to the right) from the columns. What is happening?

Thank you.

Susana
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000