cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • See how to interactively organize and restructure data for analysis. Register for May 29 webinar, 2pm US ET.

Discussions

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

Remove extra text when exporting graph builder to powerpoint

 I'm trying to remove the extra text that is currently exported along side a graph builder output.  Currently it will export the graph as one slide, then an extra slide that looks like this

 

MMuhonen_0-1637012491229.png

 

I know that the "Where(xx rows excluded)" text is stored in the IfBox.  If I manually remove or hide that, the graph will export without the extra dialogue text, but I can't seem to figure out what is the right code for removing it.

 

MMuhonen_1-1637012560236.png

vcdgb = Graph Builder(
	Size( 1200, 1000 ),
	Fit to Window("Off"),
	Show Control Panel( 0 ),
	Variables( X( :SampleDay ), Y( :y condition ), Overlay( :Experiment Cond ) ),
	Elements( Points( X, Y, Legend( 8 ) ), Line( X, Y, Legend( 10 ) ) ),
);



vcdgb << Save Presentation("C:\JMP Summary.pptx");
Open("C:\JMP Summary.pptx");

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Remove extra text when exporting graph builder to powerpoint

You should be able to remove the text box with Where.. text with Xpath:

 

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

dt << Select Where(:sex == "M") << Hide and Exclude(1) << Clear Select;

obj = dt << Graph Builder(
	Variables(X(:Sex), Y(:Height), Group X(:Age)),
	Elements(Box Plot(X, Y))
);

wait(1);

(Report(obj) << XPath("//TextBox[contains(text(),'Where(')]")) << delete;
-Jarmo

View solution in original post

3 REPLIES 3
jthi
Super User

Re: Remove extra text when exporting graph builder to powerpoint

You should be able to remove the text box with Where.. text with Xpath:

 

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

dt << Select Where(:sex == "M") << Hide and Exclude(1) << Clear Select;

obj = dt << Graph Builder(
	Variables(X(:Sex), Y(:Height), Group X(:Age)),
	Elements(Box Plot(X, Y))
);

wait(1);

(Report(obj) << XPath("//TextBox[contains(text(),'Where(')]")) << delete;
-Jarmo

Re: Remove extra text when exporting graph builder to powerpoint

This solution directly addresses the request, but I caution about always using the << Delete message to eliminate a display box. There is always the possibility that such action might adversely affect the behavior of the display tree. Rather than delete the object, consider sending the << Visibility( "Collapse" ) message instead.

 

This suggestion falls under a practice I teach called 'defensive scripting.'

MMuhonen
Level I

Re: Remove extra text when exporting graph builder to powerpoint

That worked! Thank you!

Recommended Articles