Hello,
There is a way to do this, and it includes just a few more steps since we are dealing with two separate layers (doubley) and y values sharing the same x value.
Say you have a worksheet that is originally set up as XYY:
A(X) B(Y) C(Y)
1 1 1.5
2 2 2.5
3 3 3.5
4 4 4.5
5 5 5.5
In order to 'off-set' the columns so that they can 'share' the same space at the same value along the X axis, add two blank columns in your worksheet (highlight your 3rd column (or column C) and select the menu option Edit:Insert and again Edit:Insert to add 2 new blank columns):
A(X) B(Y) E(Y) D(Y) C(Y)
1 1 -- -- 1.5
2 2 -- -- 2.5
3 3 -- -- 3.5
4 4 -- -- 4.5
5 5 -- -- 5.5
Then open up a blank doubley.OTP graph window and add the first two columns (B and E) to the layer and make sure they are grouped, then add the second two columns (D and C) and make sure they're grouped.
Or you can create two column plots using the Plot:Column menu option method, whereby the datasets will automatically be grouped and you can merge all pages, arrange layers as 1 row/1 column and they will overlay. Then just switch the left axis over to the right. Sounds harder than it really is, and let me know if you don't follow this completely and I will be more explicit. But hopefully this will point you in the right direction as far as plotting the columns such that they can be placed side by side and not overlaying one another in the graph window. Good luck!!
Lorraine
OriginLab Technical Support
vertical column graph with two different y axes
Posted - 05/23/2001 : 11:23:44 AM
