| Author |
 Topic  |
|
|
AKazak
Russia
1205 Posts |
 Posted - 12/02/2020 : 07:13:54 AM
|
OriginPro 2021 (64-bit) 9.8.0.200
Windows 7 Pro x64 SP1
Greetings!
Please see the attached project: https://my.originlab.com/ftp/forum_and_kbase/Images/Grouped%20Stacked%20Column.opju
I want to Create a Tick Label Table for X-Axis for the existing graph, with the bottom row containing group numbers (column A) and the top row containing sample IDs (column A), similar to that at https://www.originlab.com/doc/Tutorials/GroupedStackedColumn.
How do I achieve this?
Related matter
I created Data worksheet by calling Create context-menu command in the graph window. However, the sheet doesn't display a yellow column label and header rows (long name, units, F(x), comments, etc.). Why does this happen? How do I get the missing rows back?
Thank you.
---
Andrey |
Edited by - AKazak on 12/02/2020 07:15:02 AM |
|
|
YimingChen
1647 Posts |
Posted - 12/02/2020 : 09:11:09 AM
|
1. Double click on the bottom x axis, under Scale tab, change Major Ticks type to By Increment and set Value to 1.
2. Under Tick Labels tab, Display subtab, change Type to Text from dataset. Change Dataset Name to Col(A).
3. Under Table subtab, check Enable box. Set Merge Labels to Between Subgroups/Subsets.
Repeat this for upper x axis, but refer to col(B) instead.
James |
 |
|
|
AKazak
Russia
1205 Posts |
Posted - 12/02/2020 : 10:45:28 AM
|
quote:
Originally posted by YimingChen
1. Double click on the bottom x axis, under Scale tab, change Major Ticks type to By Increment and set Value to 1.
2. Under Tick Labels tab, Display subtab, change Type to Text from dataset. Change Dataset Name to Col(A).
3. Under Table subtab, check Enable box. Set Merge Labels to Between Subgroups/Subsets.
Repeat this for upper x axis, but refer to col(B) instead.
James
So far so good.
Thank you.
However I noticed, that if I leave Major Ticks type to By Custom Positions, then a strange offest appears (see below).
Do you have an idea about what could cause the horizontal offset?
By the way, why the doesn't Data worksheet have yellow column label and header rows (long name, units, F(x), comments, etc.)? Is this a special kind of worksheet?
---
Andrey |
|
|
|
YimingChen
1647 Posts |
Posted - 12/02/2020 : 12:32:27 PM
|
Hi,
Custom position in table tick label is actually specifying the boundaries of table cells instead of cell centers. e.g. left boundary of first cell is 1.
The column labels rows are just hidden. Double click on the gray area of the worksheet, click Edit Column Label Rows... button to make them show.
James |
|
|
|
AKazak
Russia
1205 Posts |
Posted - 12/02/2020 : 2:02:11 PM
|
Also noticed that vertical gridlines are missing in places where two X-axis table columns coincide.
Is there a way to fix this?
Besides, how do I late the font settings of the Table Row Titles?
I haven't found a dialog/menu to make this.
---
Andrey |
|
|
|
YimingChen
1647 Posts |
Posted - 12/02/2020 : 5:22:23 PM
|
1. Turn on the major grid line.
2. Currently no way to change font of tick label title. I will report and see if more user is asking for it.
James |
|
|
|
Cecilia_syy
65 Posts |
Posted - 12/02/2020 : 8:38:25 PM
|
Hi Andrey,
We do not provide font option for table row title since it will always follow font of tick label. Do you want to set it to be a different font?
Thanks
Cecilia |
|
|
|
AKazak
Russia
1205 Posts |
Posted - 12/03/2020 : 01:52:37 AM
|
quote:
Originally posted by Cecilia_syy
Hi Andrey,
We do not provide font option for table row title since it will always follow font of tick label. Do you want to set it to be a different font?
Thanks
Cecilia
Yes. Sometimes it seems that table row titles should have font size less than that in the main text.
---
Andrey |
|
|
|
AKazak
Russia
1205 Posts |
Posted - 12/03/2020 : 02:00:51 AM
|
quote:
Originally posted by YimingChen
Hi,
Custom position in table tick label is actually specifying the boundaries of table cells instead of cell centers. e.g. left boundary of first cell is 1.
James
Is this a documented behavior?
If positive, then please share a link to read more.
quote:
Originally posted by YimingChen
Hi,
The column labels rows are just hidden. Double click on the gray area of the worksheet, click Edit Column Label Rows... button to make them show.
James
Got it!
Is this a normal behavior for a worksheet recreated from graph data?
---
Andrey |
Edited by - AKazak on 12/03/2020 02:01:13 AM |
|
|
| |
Topic |
|
|
|
Stacked Column Graph with Grouping based on column