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
 All Forums
 Origin Forum
 Origin Forum
 Grouped column plot with two y-axes

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
emk Posted - 11/05/2004 : 03:01:22 AM
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.

2   L A T E S T    R E P L I E S    (Newest First)
emk Posted - 11/07/2004 : 10:32:23 AM
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
Mike Posted - 11/05/2004 : 10:45:56 AM
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

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000