| T O P I C R E V I E W |
| CapeStoneUVT |
Posted - 01/19/2016 : 3:44:09 PM
Hi!
Ich would appreciate your help for this:
I want to build a grouped column with 3 main and each 4 subcategories.
So I used the premade one and modified it to my needs but there is one problem: The way the values are put (2 different measures/units in one column) I cant distribute the 2 sorts of values on 2 y-axes anymore.
So I built a new book but I dont see how to assign the "Conduct" to the Y Axis. I set up a 2nd layer but I think the grouping is lost.
I attached a picture of the problem.
Is a 2nd y axis possible for grouped columns/categories?
Thx! |
| 2 L A T E S T R E P L I E S (Newest First) |
| CapeStoneUVT |
Posted - 01/20/2016 : 12:39:09 PM
Thank you very much, Shirley, that helped a lot! |
| Shirley_GZ |
Posted - 01/20/2016 : 03:35:21 AM
Hi Cape,
Sorry, there is not a direct way to plot such Double-Y grouping column plot. But there is a workaround:
1. Highlight col(D) and col(G) to plot a double-Y graph.
2. Double-click on the curve to open Plot Details dialog. Select these two curves respectively and change their plot type to Column/Bar.
3. Go to Miscellaneous tab under Graph1 level, check “Column/Bar Gap/Offset across Layers” check box.
4. Click OK button. Then double-click on X axis tick label to open Axis dialog. Go to Table tab under Tick Labels tab for Bottom axis. Check Enable check box and set Number of Rows to 2.
5. Select Bottom1 and Bottom 2 respectively and do Display settings as below:
6. Select Bottom 2, do format settings as below:
7. After all, you can custom the fill color and pattern of column plots for your own needs.
You can download the project file I made here to see more details, ftp://ftp.originlab.com/incoming/Double_Y_axes_group_columns.opj
Thanks,
Shirley
Originlab Technical Service Team |
|
|
