Example of a Stacked Bar Chart

In this example, you have data about oil consumption and production for selected countries. You want to visualize oil consumption and production in a meaningful way.

Select Help > Sample Data Library and open Oil Use.jmp.

Select Graph > Graph Builder.

Select Country and drag it to the Y zone.

Figure 3.7 Country Assigned to the Y Zone

Tip: The countries are ordered in ascending alphabetical (starting point is at the bottom). To change the sorting order, use the Value Ordering or Row Order Levels properties. For details, see Value Ordering or Row Order Levels in the Using JMP book. Alternatively, you can sort using the values of a continuous variable. For details, see Order the Levels of a Categorical Variable in Graph Builder.

Select Production and Consumption and drag them to the X zone.

Markers appear on the graph for both variables with a legend identifying the two colors.

Figure 3.8 Country versus Production and Consumption

Because the default graph element is set to points, it is difficult to relate the labels to the points. Change the points to bars to make the graph easier to interpret.

Click the Bar element

Figure 3.9 Side-by-Side Bars for Production and Consumption

Experiment with the presentation of the bar chart. Change the side-by-side bars to stacked bars.

Next to Bar Style, select Stacked. See Figure 3.9.

Figure 3.10 Stacked Bars for Production and Consumption

Because production is the opposite of consumption, you would like your plot to reflect this by having the production and consumption bars point in opposite directions.

In the Variables list, right-click the column Consumption and select Transform > Negation.

This makes Consumption negative. A column called -Consumption appears in the list of columns. The column name is italicized to indicate that it is a virtual column. Use this column to plot the consumption bar in terms of negative values.

Right-click the X axis label, Production & Consumption, and select Remove > Consumption.

Select -Consumption and drag it to just above the X axis. See Figure 3.11.

Figure 3.11 Stacked Bars for Production and Negative Consumption

Negative consumption (-Consumption) is plotted on the left in red, and Production is on the right in blue. Next, use the Consumption column as an ordering variable to sort the countries by their oil consumption.

10.

Select Consumption and drag it to the right of the Y axis. Do not drop the variable until a blue polygon appears. See Figure 3.12.

Figure 3.12 Polygon for Ordering Countries by Consumption

11.

(Optional) Click Done.

The levels of Country are now ordered by Consumption. The countries that consume the most oil appear at the top of the graph. You can also see each country’s oil production.