cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-436666%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%B0%86%E5%9B%BE%E5%BD%A2%E7%94%9F%E6%88%90%E5%99%A8%E5%AF%BC%E5%87%BA%E5%88%B0%20powerpoint%20%E6%97%B6%E5%88%A0%E9%99%A4%E5%A4%9A%E4%BD%99%E7%9A%84%E6%96%87%E6%9C%AC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-436666%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E6%88%91%E6%AD%A3%E5%9C%A8%E5%B0%9D%E8%AF%95%E5%88%A0%E9%99%A4%E5%BD%93%E5%89%8D%E4%B8%8E%E5%9B%BE%E5%BD%A2%E7%94%9F%E6%88%90%E5%99%A8%E8%BE%93%E5%87%BA%E4%B8%80%E8%B5%B7%E5%AF%BC%E5%87%BA%E7%9A%84%E9%A2%9D%E5%A4%96%E6%96%87%E6%9C%AC%E3%80%82%E7%9B%AE%E5%89%8D%EF%BC%8C%E5%AE%83%E5%B0%86%E6%8A%8A%E5%9B%BE%E8%A1%A8%E5%AF%BC%E5%87%BA%E4%B8%BA%E4%B8%80%E5%BC%A0%E5%B9%BB%E7%81%AF%E7%89%87%EF%BC%8C%E7%84%B6%E5%90%8E%E5%AF%BC%E5%87%BA%E4%B8%80%E5%BC%A0%E9%A2%9D%E5%A4%96%E7%9A%84%E5%B9%BB%E7%81%AF%E7%89%87%EF%BC%8C%E5%A6%82%E4%B8%8B%E6%89%80%E7%A4%BA%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MMuhonen_0-1637012491229.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22MMuhonen_0-1637012491229.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22MMuhonen_0-1637012491229.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F37604i9D7FA083DA5FC72D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22MMuhonen_0-1637012491229.png%22%20alt%3D%22MMuhonen_0-1637012491229.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E6%88%91%E7%9F%A5%E9%81%93%E2%80%9CWhere%EF%BC%88%E6%8E%92%E9%99%A4%20xx%20%E8%A1%8C%EF%BC%89%E2%80%9D%E6%96%87%E6%9C%AC%E5%AD%98%E5%82%A8%E5%9C%A8%20IfBox%20%E4%B8%AD%E3%80%82%E5%A6%82%E6%9E%9C%E6%88%91%E6%89%8B%E5%8A%A8%E5%88%A0%E9%99%A4%E6%88%96%E9%9A%90%E8%97%8F%E5%AE%83%EF%BC%8C%E5%9B%BE%E8%A1%A8%E5%B0%86%E5%9C%A8%E6%B2%A1%E6%9C%89%E9%A2%9D%E5%A4%96%E5%AF%B9%E8%AF%9D%E6%96%87%E6%9C%AC%E7%9A%84%E6%83%85%E5%86%B5%E4%B8%8B%E5%AF%BC%E5%87%BA%EF%BC%8C%E4%BD%86%E6%88%91%E4%BC%BC%E4%B9%8E%E6%97%A0%E6%B3%95%E5%BC%84%E6%B8%85%E6%A5%9A%E5%88%A0%E9%99%A4%E5%AE%83%E7%9A%84%E6%AD%A3%E7%A1%AE%E4%BB%A3%E7%A0%81%E6%98%AF%E4%BB%80%E4%B9%88%E3%80%82%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MMuhonen_1-1637012560236.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22MMuhonen_1-1637012560236.png%22%20style%3D%22width%3A%20300px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22MMuhonen_1-1637012560236.png%22%20style%3D%22width%3A%20300px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F37605i09F974A92848DDC8%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22MMuhonen_1-1637012560236.png%22%20alt%3D%22MMuhonen_1-1637012560236.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%22%3Evcdgb%20%3D%20Graph%20Builder(%0A%20Size(%201200%2C%201000%20)%2C%0A%20Fit%20to%20Window(%22Off%22)%2C%0A%20Show%20Control%20Panel(%200%20)%2C%0A%20Variables(%20X(%20%3ASampleDay%20)%2C%20Y(%20%3Ay%20condition%20)%2C%20Overlay(%20%3AExperiment%20Cond%20)%20)%2C%0A%20Elements(%20Points(%20X%2C%20Y%2C%20Legend(%208%20)%20)%2C%20Line(%20X%2C%20Y%2C%20Legend(%2010%20)%20)%20)%2C%0A)%3B%0A%0A%0A%0Avcdgb%20%26lt%3B%26lt%3B%20Save%20Presentation(%22C%3A%5CJMP%20Summary.pptx%22)%3B%0AOpen(%22C%3A%5CJMP%20Summary.pptx%22)%3B%0A%0A%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%E8%B0%A2%E8%B0%A2%EF%BC%81%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-436666%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%E6%95%B0%E6%8D%AE%E6%B7%B7%E5%90%88%E5%92%8C%E6%B8%85%E7%90%86%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%E5%A4%A7%E8%A7%84%E6%A8%A1%E5%AE%9A%E5%88%B6%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%E8%A7%86%E7%AA%97%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-437041%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E5%B0%86%E5%9B%BE%E5%BD%A2%E7%94%9F%E6%88%90%E5%99%A8%E5%AF%BC%E5%87%BA%E5%88%B0%20powerpoint%20%E6%97%B6%E5%88%A0%E9%99%A4%E5%A4%9A%E4%BD%99%E7%9A%84%E6%96%87%E6%9C%AC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-437041%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E6%88%90%E5%8A%9F%E4%BA%86%EF%BC%81%20%E8%B0%A2%E8%B0%A2%E4%BD%A0%EF%BC%81%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-436970%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E5%B0%86%E5%9B%BE%E5%BD%A2%E7%94%9F%E6%88%90%E5%99%A8%E5%AF%BC%E5%87%BA%E5%88%B0%20powerpoint%20%E6%97%B6%E5%88%A0%E9%99%A4%E5%A4%9A%E4%BD%99%E7%9A%84%E6%96%87%E6%9C%AC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-436970%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E8%AF%A5%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88%E7%9B%B4%E6%8E%A5%E8%A7%A3%E5%86%B3%E8%AF%B7%E6%B1%82%EF%BC%8C%E4%BD%86%E6%88%91%E8%AD%A6%E5%91%8A%E5%A7%8B%E7%BB%88%E4%BD%BF%E7%94%A8%3CSTRONG%3E%26lt%3B%26lt%3B%20%E5%88%A0%E9%99%A4%3C%2FSTRONG%3E%E6%B6%88%E6%81%AF%E6%B6%88%E9%99%A4%E6%98%BE%E7%A4%BA%E6%A1%86%E3%80%82%20%E6%AD%A4%E7%B1%BB%E6%93%8D%E4%BD%9C%E5%A7%8B%E7%BB%88%E6%9C%89%E5%8F%AF%E8%83%BD%E5%AF%B9%E6%98%BE%E7%A4%BA%E6%A0%91%E7%9A%84%E8%A1%8C%E4%B8%BA%E4%BA%A7%E7%94%9F%E4%B8%8D%E5%88%A9%E5%BD%B1%E5%93%8D%E3%80%82%20%E4%B8%8D%E8%A6%81%E5%88%A0%E9%99%A4%E5%AF%B9%E8%B1%A1%EF%BC%8C%E8%80%8C%E6%98%AF%E8%80%83%E8%99%91%E5%8F%91%E9%80%81%3CSTRONG%3E%26lt%3B%26lt%3B%20%E5%8F%AF%E8%A7%81%E6%80%A7%EF%BC%88%E2%80%9C%E6%8A%98%E5%8F%A0%E2%80%9D%EF%BC%89%3C%2FSTRONG%3E%E6%B6%88%E6%81%AF%E4%BB%A3%E6%9B%BF%E3%80%82%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%E8%BF%99%E4%B8%AA%E5%BB%BA%E8%AE%AE%E5%B1%9E%E4%BA%8E%E6%88%91%E6%95%99%E6%8E%88%E7%9A%84%E4%B8%80%E7%A7%8D%E7%A7%B0%E4%B8%BA%E2%80%9C%E9%98%B2%E5%BE%A1%E6%80%A7%E8%84%9A%E6%9C%AC%E2%80%9D%E7%9A%84%E5%AE%9E%E8%B7%B5%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-436812%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E5%B0%86%E5%9B%BE%E5%BD%A2%E7%94%9F%E6%88%90%E5%99%A8%E5%AF%BC%E5%87%BA%E5%88%B0%20powerpoint%20%E6%97%B6%E5%88%A0%E9%99%A4%E5%A4%9A%E4%BD%99%E7%9A%84%E6%96%87%E6%9C%AC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-436812%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E6%82%A8%E5%BA%94%E8%AF%A5%E8%83%BD%E5%A4%9F%E4%BD%BF%E7%94%A8%20Xpath%20%E5%88%A0%E9%99%A4%E5%B8%A6%E6%9C%89Where..%E6%96%87%E6%9C%AC%E7%9A%84%E6%96%87%E6%9C%AC%E6%A1%86%EF%BC%9A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%22%3ENames%20Default%20To%20Here(1)%3B%0Adt%20%3D%20Open(%22%24SAMPLE_DATA%2FBig%20Class.jmp%22)%3B%0A%0Adt%20%26lt%3B%26lt%3B%20Select%20Where(%3Asex%20%3D%3D%20%22M%22)%20%26lt%3B%26lt%3B%20Hide%20and%20Exclude(1)%20%26lt%3B%26lt%3B%20Clear%20Select%3B%0A%0Aobj%20%3D%20dt%20%26lt%3B%26lt%3B%20Graph%20Builder(%0A%20Variables(X(%3ASex)%2C%20Y(%3AHeight)%2C%20Group%20X(%3AAge))%2C%0A%20Elements(Box%20Plot(X%2C%20Y))%0A)%3B%0A%0Await(1)%3B%0A%0A(Report(obj)%20%26lt%3B%26lt%3B%20XPath(%22%2F%2FTextBox%5Bcontains(text()%2C'Where(')%5D%22))%20%26lt%3B%26lt%3B%20delete%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
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