Table: Bar plot where...

Draws a bar plot from data in one or more columns of the selected Table. In a bar plot the horizontal axis has nominal values (labels).


Vertical column(s)
you list the table columns that you want to represent in the bar plot. The number of selected columns is the group size.
Vertical range
determine the lower and upper limit of the display.
Column with labels
determines the column whose labels will be put at the bottom of the plot.
Distance of first bar from border
determines how far the first (and last) bar wil be positioned from the borders (in units of the width of one bar).
Distance between bar groups
determines how far groups of bars are from each other.
Distance between bars within group
determines the distance between the bars within each group.
determines the colours of the bars in a group.
Label text angle (degrees)
determines the angle of the labels written below the plot. If you have very long label texts you can prevent the label texts from overlapping.
can be used to supply an expression to select only those rows for plotting where the expression evaluates to true. A 1 value always evaluates to true.


Keating & Esposito (2006) present a bar plot in their fig. 3 from which we estimate the following data table

Language Modal Breathy
Chong -1.5 5
Fuzhou 2 10
Green Hmong 3 12
White Hmong 2 11
Mon -1.5 0
SADV Zapotec -6 -4
SLQ Zapotec 3.5 14
Tlacolula Zapotec 3 13
Tamang 1 1
!Xoo 1 14

Given that we have these data in a Table with the three columns labeled "Language", "Modal" and "Breathy", respectively, we can first try to reproduce their figure 3 (a bar plot with both Modal and Breathy columns displayed)

As you can see the labels in the first column are very long texts and they will surely overlap if plotted at the bottom of a plot. We therefore use a value of 15 degrees for the "Label text angle" parameter. This will make the label texts nonoverlapping. We cannot make this angle much larger because then the label texts will run out of the viewport.

Sometimes you need to plot only a part of the Table and for the selection of this part, the "Formula" field can be used. Since we only have a small table we put a "1" in this field which always evaluates to true. In effect, all the rows will be selected. The following script line will produce the picture below.

Bar plot where: "Modal Breathy", -10, 20, "Language", 1.0, 1.0, 0.0, "0.9 0.5", 15.0, "yes", "1"

The essentials of the bart plot in their paper are perfectly reproduced in the figure above. If you want the bars within a group to be placed somewhat more apart say 0.2 (times the bar width) you can set the "Distance between bars in a group" to a value of 0.2:

Bar plot where: "Modal Breathy", -10, 20, "Language", 1.0, 1.0, 0.2, "0.9 0.5", 15.0, "yes", "1"

Of course we can also work with colours and we can add vertical marks as the following sriptlet shows

Bar plot where: "Modal Breathy", -10, 20, "Language", 1.0, 1.0, 0.0, "Green Red", 15.0, "yes", "1"
Marks left every: 1, 5, 1, 1, 1
Text left: 1, "H1-H2 (dB)"

© djmw, May 9, 2014