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
 Grouped column plot with two y-axes
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

emk

Finland
28 Posts

Posted - 11/05/2004 :  03:01:22 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Version: 7.0 SR4
Operating System: XP sp 2

How do you create a column plot that is just like a normal column plot with two y-columns (grouped colums), but both column series have y-axis of their own? The problem is in adjusting the column offsets and spacing when two layers are used.

Mike

USA
357 Posts

Posted - 11/05/2004 :  10:45:56 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi emk:

This requires a bit of fiddling but it can be done.

  1. Insert an empty column between the two Y columns of your worksheet. Now you have three Y columns.


  2. Select the first two columns (the second Y column will be empty, of course) and make your column graph
  3. .

  4. Add a linked "Right Y" axis to your column graph (Edit:New Layer(Axes):Linked:(Right Y). The column graph now has two layers. You may need to adjust the right Y axis' From and To values.


  5. Click once on the graph's layer 2 icon to make sure that layer 2 is active, then select the second and third Y column (again, the second column is empty) and drag your selection to the graph.


  6. Open the graph's Plot Details dialog box. Select the layer 2 data sets and on the Group tab, set Edit Mode to Independent. Once done, you can change the appearance of the third Y column plot to suit you.


So what you are doing is creating and twice plotting an empty data set, which then acts as a "placeholder." Let me know if I haven't been clear enough. Good luck to you.

Mike
OriginLab

Edited by - Mike on 11/05/2004 10:47:14 AM
Go to Top of Page

emk

Finland
28 Posts

Posted - 11/07/2004 :  10:32:23 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thanks Mike! This is just what I was looking for. I tried something similar with dummy data not plotted but used to direct the formatting. Now I realize that the problem I had was due to my x-axis not being categorical (for some reason Origin seems to rescale the x-axis for the second layer and if the x-axis is not categorical, the columns are misplaced). I created a template to plot similar data, now I only need to create the dummy column in btw the real data and plot/template does the rest.
(One might ask why to plot columns with two y-axes as you normally use this plot to facilitate column height comparisons, but we want to show that the paired colums behave similarly relative to the category)
__
Eero



Edited by - emk on 11/08/2004 05:45:05 AM
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