| Author |
 Topic  |
|
|
hguzman
Canada
4 Posts |
 Posted - 10/28/2015 : 01:25:55 AM
|
[size=5][size=3]Origin Ver. and Service Release (Select Help-->About Origin): 2015
Operating System: Windows 8
Hello all,
I'm trying to build a grouped column indexed data plot but I'm having some problem with the ordering of the subsets once the plot is complete; as an example, let's say I have 3 solids A B and C with some specific values to each one and they underwent some treatment to see how those values were changed:
Solid Value (X axis) before
A 230
B 229
C 228
A1 229 after
B1 228
C1 227
I set both columns as categorical expecting to have the subset sequence ABC A1B1C1, but instead I obtain ABA1 CB1C1 because the software set the value of 229 as the same category and plot both columns together. By the way, this is only for the X axis, the values for the Y axis present no problems whatsoever.
What do I need to do to have the plot with the desired sequence showing their corresponding values while keeping them as separates categories ?. |
|
|
SeanMao
China
288 Posts |
Posted - 10/28/2015 : 02:06:04 AM
|
Hi,
Suppose you have the data like below:
To make the plot you want, you simply need to highlight column C and go to menu Plot: Column/Bar/Pie: Grouped Columns-indexed data and select group columns as column B then column A as shown below:
Then click OK button you will have this plot:
If you want to change the order as "Before" then "After", you can go to data sheet and highlight column A and right click to select Set as Categorical and manipulate its order.
See tutorial below for more details of how to set it:
http://www.originlab.com/doc/Tutorials/Categorical-Values-Ordering
Hope this is what you want. If not, please explain in more details.
Regards!
Sean
OriginLab Tech. Service |
Edited by - SeanMao on 10/28/2015 02:13:07 AM |
 |
|
|
hguzman
Canada
4 Posts |
Posted - 10/28/2015 : 02:53:50 AM
|
Thank you Sean, but this what I meant
Look at the plot
I want it that way but with the sequence ABC A1B1C1 NOT THE SEQUENCE ABA1 CB1C1.
Thanks in advance. |
|
|
|
SeanMao
China
288 Posts |
Posted - 10/28/2015 : 04:03:00 AM
|
Hi,
Do you mean you want to plot like this:
Regards!
Sean
|
Edited by - SeanMao on 10/28/2015 04:16:53 AM |
|
|
|
hguzman
Canada
4 Posts |
Posted - 10/28/2015 : 11:34:42 AM
|
Exactly Sean,
That's what I'm looking for. I honestly don't know how to do it.
|
|
|
|
SeanMao
China
288 Posts |
Posted - 10/28/2015 : 9:29:56 PM
|
Hi,
You can refer to the figure below, highlight column C ("Data") and go to menu Plot:Column/Bar/Pie:Grouped Columns-Indexed Data to open dialog. Select "Group Column(s)" as shown:
Click OK you will have the graph you want.
Regards!
Sean |
|
|
|
hguzman
Canada
4 Posts |
Posted - 10/28/2015 : 11:11:31 PM
|
Sean, I follow the exact same steps but for some reason it does not follow the sequence I want:
 |
|
|
|
SeanMao
China
288 Posts |
Posted - 10/29/2015 : 01:49:29 AM
|
Hi,
You should have two axis label rows, but I only saw one. Did you just hide it? You can double click on the X axis labels and you should see Bottom1 and Bottom2 options on the left panel:
If hidden, you can check Show box to reveal it.
I made one like this:
Can you send your sample opj file to tech@originlab.com so I can try on my side?
Thanks!
Regards!
Sean |
Edited by - SeanMao on 10/29/2015 01:54:03 AM |
|
|
|
SeanMao
China
288 Posts |
Posted - 10/29/2015 : 11:19:40 PM
|
Hi,
I have replied to you in email. Please check.
The solution to this is to plot a simple column plot instead of grouped column and manually add X axis tick label table row and customize the color indexing.
Regards!
Sean |
|
|
| |
Topic |
|
Grouped column indexed data plot