openmolecules.org Forum: Functionality » Bar chart representaion of data

Home » DataWarrior » Functionality » Bar chart representaion of data (Excel-like way to represent multiple values for each molecule)

Show: Today's Messages :: Polls :: Message Navigator

Bar chart representaion of data [message #394]

Fri, 12 October 2018 10:14

pedro-ccfht
Messages: 2
Registered: October 2018

Junior Member

Is there a way to use compoundID as category value, select several collumns with data and represent them like in a file attached?

index.php?t=getfile&id=44&private=0

Attachment: Clipboard01.png
(Size: 7.49KB, Downloaded 800 times)

Report message to a moderator

Re: Bar chart representaion of data [message #395 is a reply to message #394]

Mon, 15 October 2018 20:59

thomas
Messages: 715
Registered: June 2014

Senior Member

yes, with the following data
- create a 2D view with preferred view 'bar chart' with bars representing mean of value
- choose 'CompoundID' and unassigned for the two axes
- set marker color to 'Type'
- separate cases by 'Type'

CompoundID Type Value
ID1 A 12
ID1 B 17
ID1 C 13
ID2 A 14
ID2 B 9
ID2 C 11
ID3 A 8
ID3 B 12
ID3 C 15

index.php?t=getfile&id=45&private=0

this should come close, Thomas

Attachment: image.png
(Size: 8.26KB, Downloaded 703 times)

Report message to a moderator

Re: Bar chart representaion of data [message #396 is a reply to message #395]

Tue, 16 October 2018 08:59

pedro-ccfht
Messages: 2
Registered: October 2018

Junior Member

thomas, thank you very much for the reply!
i assume, there should have been done reverse pivoting with my table? i did it. however, i don't really get your instruction in the part of "- choose 'CompoundID'". where should i choose it? obviously not in bar chart settings, as there are only numerical fields available.

Report message to a moderator

Re: Bar chart representaion of data [message #408 is a reply to message #396]

Thu, 25 October 2018 22:07

thomas
Messages: 715
Registered: June 2014

Senior Member

sorry for the delay. Press the 'xyz' button in the blue title area of the 2D-view. This opens a popup with comboboxes and sliders to assign columns to axes and to zoom into them, respectively. Select 'CompoundID' on one axis (combobox) and '<unassigned>' on the other. I hope, this explains it...

Thomas

Report message to a moderator

Previous Topic:	Boxplot sorting order
Next Topic:	Using Arrow Keys to Navigate Structures Panel

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Nov 22 03:30:50 CET 2024

Total time taken to generate the page: 0.03586 seconds