The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 plotting with categories		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

anthrazius

Austria
2 Posts
Posted - 09/17/2026 :  03:24:22 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin):
Operating System: OriginPro 2026 (64-bit) 10.3.0.180

Is it possible to connect categories across different worksheets?
When I am plotting e.g. a bar chart of different worksheets with categories put on the x-axis, categories with the same name but in different worksheets are treated as different.

Thanks

snowli

USA
1493 Posts
Posted - 09/17/2026 :  08:42:03 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Yes, u can use categorical columns to specifiy exact order you want on x axis
Visit https://docs.originlab.com/tutorials/categorical-values-ordering/#Share_Categorical_Values to see more info.


E.g. Set the X data's corresponding column in worksheet as categorical.
Then Categories label row will appear in worksheet.
Double click the cell to modify the category orders. By default it's unsorted so it will be based on appearance order.
E.g. U can check Customize Categories checkbox and set your fixed order.

After set it in one worksheet, click the categories cell and Ctrl+C.
Then highlight other worksheet's X column header, Ctrl+V to apply the same category order in other sheet.

Then plot column/bar will use the same order on X axis.




Thanks, Snow
Go to Top of Page

anthrazius

Austria
2 Posts
Posted - 09/17/2026 :  08:55:00 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thank you very much!
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000