topic Re: How do I get labels to 'stack' in graph builder? in Discussions

How do I get labels to 'stack' in graph builder?

patriciafm811 — Thu, 22 Jun 2023 14:56:45 GMT

Hello. I am trying to get the labels in this map to be 'stacked' (so that it says the abbreviation on one line and then the number on the next line). Is there a way to do this? Thank you!

Re: How do I get labels to 'stack' in graph builder?

jthi — Thu, 22 Jun 2023 15:20:20 GMT

I think one fairly easy option which should work is to create new column with ",\!N" as separator between different values.

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");

:name << Label(0);
new_col = dt << New Column("LABEL", Character, Nominal, Formula(
	Char(:height) ||",\!N" || Char(:weight)
));
new_col << Label(1);

gb = dt << Graph Builder(
	Size(1029, 499),
	Variables(X(:name), Y(:height)),
	Elements(Bar(X, Y, Legend(6), Label("Label by Row")))
);

Re: How do I get labels to 'stack' in graph builder?

patriciafm811 — Thu, 22 Jun 2023 16:20:41 GMT

So I tried this and I can't get it to work in the map.

Re: How do I get labels to 'stack' in graph builder?

jthi — Thu, 22 Jun 2023 16:37:06 GMT

Seems to work here

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/CrimeData.jmp");

dt << New Column("LABEL", Character, Nominal, Label(1), Formula(
	:Region || ",\!N" || :State
));

:Region << Label(0);
:State << Label(0);
:Year << Label(0);

dt << Select Where(Row() != Col Min(Row(), :State)) << Hide and Exclude(1);

dt << Select Where(Row() == Col Min(Row(), :State)) << Label << Clear Select;

gb = dt << Graph Builder(
	Variables(Color(:Total Rate), Shape(:State)),
	Elements(Map Shapes())
);

Do you happen to have multiple values for each map shape?

Re: How do I get labels to 'stack' in graph builder?

patriciafm811 — Thu, 22 Jun 2023 17:06:15 GMT

I can't seem to get it.

Re: How do I get labels to 'stack' in graph builder?

jthi — Thu, 22 Jun 2023 17:28:46 GMT

You have to use label only on the formula column. And I'm not sure if you can write row change to the column by hand (that is why I did use formula with concatenation). You can see that the "\!N" is not visible in my rows

(I'm using JMP17)