nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to create a bar-mekko chart (variable width bar chart) in JMP / Graph Builder

Achim_T

Is it possible to create a bar-mekko chart in JMP? see e.g.

https://kb.tableau.com/articles/howto/create-a-variable-width-bar-chart-aka-cascade-chart

I can create a bar chart with categories on the X-axis and Numerical on the Y-axis, and sort ascending. Then, intuitively, dragging another numerical column to the "Size" field should create such a chart (Size = widths of the bars in the chart?) but nothing happens if I do that. I can only color the bars instead, i.e. dragging to the "Color" field in the Graph builder.

Thanks in advance for any help.

Accepted answers

Dan_Obermiller

Two options that I can think of (neither is a bar chart) that would get you close are:

1) don't use bars. Stick with a scatterplot and set the size of the point to be the production size. That would give you something like this:

Graph Builder.png

2) use Fit Y by X, put the Production Size in as a Frequency variable (Fit Y by X has an X-axis proportional default setting). That gives you something like this:

Fit Y by X.png

You could play around with some additional options to try and make them look a bit better.

Of course you could always write a script to do this.

All comments

MikeD_Anderson

I'd try a packed bar chart - it's one of the options for bar charts in JMP 14.

https://community.jmp.com/t5/JMP-Blog/Introducing-packed-bars-a-new-chart-form/ba-p/39972

Achim_T

Thanks Mike, I had looked at that but this is not really what I intend here. Also, packed bars get very confusing because unrelated categories are mixed. The variable width bar charts are very common in the mining / oil & gas world, e.g. production cost on the y-axis, mine/well name as category on the x-axis, and mine/well production size as bar width. Would be cool if this could be added in the graph builder at some point (like I described via dragging a column on the size field with a bar chart).

Dan_Obermiller

Two options that I can think of (neither is a bar chart) that would get you close are:

1) don't use bars. Stick with a scatterplot and set the size of the point to be the production size. That would give you something like this:

Graph Builder.png

2) use Fit Y by X, put the Production Size in as a Frequency variable (Fit Y by X has an X-axis proportional default setting). That gives you something like this:

Fit Y by X.png

You could play around with some additional options to try and make them look a bit better.

Of course you could always write a script to do this.

Achim_T

Thanks Dan, I will try the scripting and the suggested alternatives.

Jeff_Perkinson

Starting with JMP 16 the bars element will support the size role to allow for this kind of chart.

ThomasBBB

In JMP17, Size is an element in the bar chart of the Chart Builder. However, assigning a quantitative column to this element does not change the bar widths.

Below is an example with state population data. The intention is for the bar width to be proprotional to the state population. That is similar to what user Achim_T wanted to do.