| 
        
          | 
              
                | Author |  Topic  |           |  
                | emk
 
                Finland28 Posts
 | 
                    
                      |  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.
 
 
 |  |  
                | Mike
 
                USA357 Posts
 | 
                    
                      |  Posted - 11/05/2004 :  10:45:56 AM           
 |  
                      | Hi emk: 
 This requires a bit of fiddling but it can be done.
 
 
 Insert an empty column between the two Y columns of your worksheet.  Now you have three Y columns.
 
 Select the first two columns (the second Y column will be empty, of course) and make your column graph.
 
 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.
 
 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.
 
 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
 |  
                      |  |  |  
                | emk
 
                Finland28 Posts
 | 
                    
                      |  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
 |  
                      |  |  |  
                |  |  Topic  |           |  |  |