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
 bar graph with more then one bar
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

matpow

Germany
6 Posts

Posted - 11/02/2021 :  3:01:36 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hey @all,

i would like to create a bar graph with more than one bar.
Like this:



My data looks like this:



But i get only this:



if i select all columns, i will get this:



Thanks a lot for help

BG Matpow

matpow

Germany
6 Posts

Posted - 11/02/2021 :  3:24:53 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Now i have this:



but the assignment does not figure.
Go to Top of Page

snowli

USA
1386 Posts

Posted - 11/02/2021 :  3:37:26 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
What version of Origin are you using and what plot type did you choose.

What does your source data looks like before you reoranize them into different columns.
I think u can use Plot: Categorical: Grouped Column - Indexed to plot our original source data if group info. is in one column, which will be easier than you reorganize data first and then plot.
Press F11 and search Grouped column to find example.

Thanks, Snow
Go to Top of Page

matpow

Germany
6 Posts

Posted - 11/03/2021 :  08:59:13 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi snowli

i am using OriginLab 2021b.
my data looks like this before i reorganize them:



i take "grouped columns" for the last picture.
Go to Top of Page

snowli

USA
1386 Posts

Posted - 11/03/2021 :  09:16:27 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi BG Matpow,

There are many Rermanenz columns so I am not sure which one u want to plot.
But supposing you want to plot column D and E against group information in column B and A, here is what you can do.

Highlight column D and E and choose Plot: Categorical: Grouped Column - Indexed.
In the dialog, click the > button in Column Columns and choose Column B (temperature) first.
Then click > again and choose column A (magnetic field).
Click OK.
--> It will plot column bar with error against group information in column A and B.

A is 1st in the group columns field so it's the bigger group. B is the 2nd so it's the smaller group with in group A.
The color of columns are based on the smaller group.

Thanks, Snow
Go to Top of Page

matpow

Germany
6 Posts

Posted - 11/03/2021 :  1:13:01 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Snow,

THANKS ALOT!!! There is my diagram/result.



Last question: the order of the numbers is not correct. 75 and 150 are at the end, but 75 should logically between 55 and 100. Same fot 150. Do you know?

best regards matpow
Go to Top of Page

snowli

USA
1386 Posts

Posted - 11/03/2021 :  2:21:58 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi BG Matpow,
When setting columns A & B as group columns, they are treated like categorical text and by default we use the appearance order.

The 1st appearence of 75 and 150 must be after all other numbers have shown.

Here how to manually control orders.
1. In original sheet, right click column A & B and check "Set as Categorical". Choose Yes to the prompts.
U will see the data all are left-aligned which means they are treated as text now.
A Categorical row shows with "Unsorted" in it. Unsorted means using appearance order.

2. Double click Unsorted and in the dialog, change Sort to be Ascending for column A and B.
--> Graph will auto update.

Note: U can also check Customize Categoricals to define your own order.

Thanks, Snow


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