openmolecules.org Forum: Functionality » line or bar chart representation in 3D view

Home » DataWarrior » Functionality » line or bar chart representation in 3D view (bar chart)

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

line or bar chart representation in 3D view [message #609]

Fri, 23 August 2019 04:45

dongkeke
Messages: 7
Registered: June 2019
Location: 中国

Junior Member

Hi Thomas,

The data format is like this: x is a series of different tags, y is another series of different tags, z is the counts coresponding with x and y.

Now I would like to display line or bar for z, which is perpendicular to the plane of x and y. But I don't know how to get this kind of figure.

Is there the feature?

Best wishes

Kelly

Dong_Keke

Report message to a moderator

Re: line or bar chart representation in 3D view [message #614 is a reply to message #609]

Sat, 24 August 2019 00:51

thomas
Messages: 648
Registered: June 2014

Senior Member

Hi Kelly,

like this?

X Y Z
A C 4
B C 2
A D 3
B D 1

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

This would be x and y on axes, third axis unassigned, preferred chart type: bars with size by mean of z

Does this answer your question?

Thomas

Attachment: t.png
(Size: 45.15KB, Downloaded 558 times)

Report message to a moderator

Re: line or bar chart representation in 3D view [message #619 is a reply to message #614]

Thu, 29 August 2019 06:56

dongkeke
Messages: 7
Registered: June 2019
Location: 中国

Junior Member

Thanks Thomas.

I have tried and it works for this example.

But when I used other data which have more than 1000 lines, it just displayed dots. Is there a limit for the data size?

Dong_Keke

Report message to a moderator

Re: line or bar chart representation in 3D view [message #624 is a reply to message #619]

Fri, 06 September 2019 19:18

thomas
Messages: 648
Registered: June 2014

Senior Member

Hi Kelly,

the limitation is that you need to assign categories to two axes and if there are more than 256 categories in a column, that column cannot be used for this purpose. The third column must be 'unassigned'. Otherwise you get a 3D-scatter plot. Realistically, if you have more than 256 categories, the bars won't be recognizable anymore. The following picture shows 100 by 100 bars:

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