topic Re: Add reference line to Y-group axis in Discussions

Add reference line to Y-group axis

patriciafm811 — Tue, 30 Jan 2024 18:59:39 GMT

Hello,

I am using graph builder (JMP 17) and have almost what I need. But I need to add a reference line.

This first image ('example') is what I currently have (I need all 3 viruses in 1 graph with lines and dots for the rates for both years).

BUT, I need to add a reference line for each virus so that it looks like 'example with ref line' (below).

I don't know if it is possible. But essentially, I am trying to get a reference line to show up for each one my y-groups. I can use JSL if someone has something that will work using scripts.

Re: Add reference line to Y-group axis

jthi — Tue, 30 Jan 2024 19:08:45 GMT

Based on what is the reference line plotted from? How does your data look like?

Re: Add reference line to Y-group axis

patriciafm811 — Tue, 30 Jan 2024 19:20:50 GMT

The blue and red lines are my data, but I want to add in a CDC line (which is only available for the year and not monthly like my data) as the green line.

Re: Add reference line to Y-group axis

jthi — Tue, 30 Jan 2024 19:45:41 GMT

Depending on how your data is formatted, you might be able to add it as a separate line graph or you could add reference lines through scripting.

Re: Add reference line to Y-group axis

patriciafm811 — Tue, 30 Jan 2024 19:51:07 GMT

I don't want it as a separate line graph. I just don't know how to do the script for it.

Re: Add reference line to Y-group axis

jthi — Tue, 30 Jan 2024 19:54:48 GMT

Is there a specific reason for not wanting separate line graph?

Re: Add reference line to Y-group axis

patriciafm811 — Tue, 30 Jan 2024 20:01:17 GMT

It isn't really a line graph if there is only 1 data point (from the CDC). We just need it as a reference, not part of the actual data.

Re: Add reference line to Y-group axis

jthi — Tue, 30 Jan 2024 20:04:42 GMT

You can go the complicated way of using graphic script

Names Default To Here(1); 

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

gb = dt << Graph Builder(
	Variables(X(:weight), Y(:height), Group Y(:sex)),
	Elements(Points(X, Y, Legend(11)))
);

fbs = Report(gb) << XPath("//FrameBox");
lines = {60, 65};

For Each({fb, idx}, fbs,
	Eval(EvalExpr(
		fb << Add Graphics Script(
			H Line(Expr(lines[idx]));
		);
	));
);

or easier option of adding new chart

Names Default To Here(1); 

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

dt << New Column("Line", Numeric, Continuous, << Set Each Value(
	If(:sex == "M", 65, 60)
));

gb = dt << Graph Builder(
	Size(567, 523),
	Show Control Panel(0),
	Variables(X(:weight), Y(:height), Y(:Line, Position(1)), Group Y(:sex)),
	Elements(Points(X, Y(1), Legend(8)), Line(Y(2), Legend(10)))
);

Re: Add reference line to Y-group axis

Florian_Vogt — Tue, 30 Jan 2024 20:31:13 GMT

...and you could do a slightly different version of that by using the "Page" function. That allows you to specify individual Ref lines per Virus. However the visual is not so nice, since it creates 3 different graphs basically:

Best

Florian

Re: Add reference line to Y-group axis

pmroz — Tue, 30 Jan 2024 20:36:07 GMT

You can add the horizontal line in Graph Builder. Double-click on the Y axis and put a value in to the reference line section.

Re: Add reference line to Y-group axis

patriciafm811 — Wed, 31 Jan 2024 13:09:17 GMT

But I need to do this for the Y-Group, not the Y-Axis.

Re: Add reference line to Y-group axis

jthi — Wed, 31 Jan 2024 17:12:31 GMT

Not sure anymore what lines we are plotting here

Names Default To Here(1); 

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

gb = dt << Graph Builder(
	Variables(X(:weight), Y(:height), Group Y(:sex)),
	Elements(Points(X, Y, Legend(11)))
);

fbs = Report(gb) << XPath("//FrameBox");

lines = {60, 65};

For Each({fb, idx}, fbs,
	fb << Add Line Annotation(Line({478, (192 / (70.76 - 50)) * (70.76 - lines[idx])}, {478 + 42, (192 / (70.76 - 50)) * (70.76 - lines[idx])}), Color("Blue"));
);

Re: Add reference line to Y-group axis

patriciafm811 — Wed, 31 Jan 2024 18:31:59 GMT

Attached is the data file. I only need 2022 and 2023 in the final graph.

This is what it should like (but instead of gray lines, they are green, and actually in there instead of just drawn in manually at a guess). The line for HIV is 12.7, HCV is 1.6, and HBV is 0.6.

Re: Add reference line to Y-group axis

jthi — Wed, 31 Jan 2024 19:10:07 GMT

I still think it would be better to create new column into your data table with the values and use separate line chart, but here is graphic script version

Names Default To Here(1);

dt = Open("$DOWNLOADS/Stacked Combined CSV files.jmp");

gb = dt << Run Script("PPTA Overall Infection Rates All");

fbs = Report(gb) << XPath("//FrameBox");
lines = {12.7, 1.6, 0.6}; // These must be in correct order (using associative array could be better idea

For Each({fb, idx}, fbs,
	Eval(EvalExpr(
		fb << Add Graphics Script(
			Pen Color("Green");
			H Line(Expr(lines[idx]));
		);
	));
);

Re: Add reference line to Y-group axis

patriciafm811 — Wed, 31 Jan 2024 19:31:59 GMT

I will try this. I don't want to add columns to the existing file.