cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
patriciafm811
Level II

Add reference line to Y-group axis

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). 

patriciafm811_0-1706640947824.png

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

patriciafm811_1-1706641063371.png

 

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. 

14 REPLIES 14
jthi
Super User

Re: Add reference line to Y-group axis

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

-Jarmo
patriciafm811
Level II

Re: Add reference line to Y-group axis

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. 

jthi
Super User

Re: Add reference line to Y-group axis

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.

-Jarmo
patriciafm811
Level II

Re: Add reference line to Y-group axis

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

jthi
Super User

Re: Add reference line to Y-group axis

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

-Jarmo
patriciafm811
Level II

Re: Add reference line to Y-group axis

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. 

jthi
Super User

Re: Add reference line to Y-group axis

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)))
);
-Jarmo
pmroz
Super User

Re: Add reference line to Y-group axis

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.

pmroz_1-1706646913453.png

 

pmroz_2-1706646934846.png

 

 

patriciafm811
Level II

Re: Add reference line to Y-group axis

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