cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to create experiments to support product design and ID useful product features. Register for June 12 webinar, 2pm US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
Cdougz
Level II

separating labelled values from graph points

I have looked in the scripting help section and all over this community and haven't found a solution for my problem so hopefully someone can help. I have a graph containing two trend lines and a bar graph and want to label the values of each point but when I set the labels both values show up on each trend line and I can't figure out how to separate the labels. I tried stacking the labelled columns to use overlay to separate them on the graph but I already have a different overlay for the bar graph and couldn't figure out how to use a second overlay to separate the labeled points. I copied my code and a picture of the graph i'm working with here and attached the script i'm running with the data table. Any help or insight is very much appreciated.

 

Cdougz_0-1640964720518.png

Data Table ("Graph Subset"):Month EQ Hrs << Set labelled;
Data Table ("Graph Subset"):Total Available Hrs << Set labelled;

Data Table ("Graph Subset") << select where( :Month == 1 | :Month == 2 |:Month == 3 | :Month == 4 | :Month == 5 | :Month == 6 | :Month == 7 | :Month == 8 | :Month == 9 | :Month == 10 | :Month == 11 | :Month == 12) << label;
Graph Builder(
	Size( 1352, 731 ),
	Variables(
		X( :Month Name ),
		Y( :Total EQ Hours ),
		Y( :Month EQ Hrs, Position( 1 ) ),
		Y( :Total Available Hrs, Position( 1 ), Side( "Right" ) ),
		Y( :Available Hrs, Position( 1 ), Side( "Right" ) ),
		Group X( :Year ),
		Overlay( :ePlexProcess )
	),
	Elements(
		Bar(
			X,
			Y( 1 ),
			Legend( 4 ),
			Bar Style( "Stacked" ),
			Summary Statistic( "Sum" ),
			Label( "Label by Value" )
		),
		Line( X, Y( 1 ), Overlay( 0 ), Legend( 5 ), Summary Statistic( "Sum" ) ),
		Points(
			X,
			Y( 1 ),
			Overlay( 0 ),
			Legend( 6 ),
			Summary Statistic( "Sum" ),
			Jitter( "None" )
		),
		Line( X, Y( 4 ), Overlay( 0 ), Legend( 5 ), Summary Statistic( "Sum" ) ),
		Points(
			X,
			Y( 3 ),
			Overlay( 0 ),
			Legend( 6 ),
			Summary Statistic( "Mean" ),
			Jitter( "None" )
		)
	),
	SendToReport(
		Dispatch( {"Bar"}, "", OutlineBox, {Close( 0 )} ),
		Dispatch( {"Line"}, "", OutlineBox, {Close( 0 )} ),
		Dispatch( {"Line (right)"}, "", OutlineBox, {Close( 0 )} ),
		Dispatch( {}, "Total EQ Hours", ScaleBox, {Max( 4500 )} ),
		Dispatch(
			{},
			"Total Available Hrs",
			ScaleBox,
			{Min( 0 ), Max( 24000 ), Inc( 5000 ), Minor Ticks( 2 ),
			Label Row(
				{Show Major Grid( 1 ), Show Minor Grid( 1 ), Show Minor Labels( 1 ),
				Set Font Size( 12 )}
			)}
		),
		Dispatch(
			{},
			"400",
			ScaleBox,
			{Legend Model( 6, Base( 0, 0, 0, Item ID( "Sum(Total EQ Hours)", 1 ) ) )
			}
		),
		Dispatch(
			{},
			"400",
			LegendBox,
			{Legend Position(
				{4, [0, 1, 2, 3, 4, 5], 5, [7], 6, [9], 5, [7], 6, [9]}
			), Position( {0, 1, 2, 3, 4, 5, 7, 9, 7, 9} )}
		)
	)
);
0 REPLIES 0

Recommended Articles