Re: Export to Powerpoint

[Brock-15]

Where exactly do you do the Document Object > Open?  Is that in
Powerpoint?  I am trying to do the same exact thing as the question posed,
except that I export my Charts manually by right-clicking on the specific
chart.

~ Brock

[Peck, Jon]

Document Object is on the context (right-click) menu in PowerPoint, not in SPSS.  It applies to table objects, though, not charts.  The export format we have to use for putting charts in PowerPoint does not permit editing individual parts of the chart.  It   You would have to do those edits on the SPSS side before exporting.

-Jon Peck

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of [hidden email]
Sent: Wednesday, January 17, 2007 8:08 AM
To: [hidden email]
Subject: Re: [SPSSX-L] Export to Powerpoint

Where exactly do you do the Document Object > Open?  Is that in
Powerpoint?  I am trying to do the same exact thing as the question posed,
except that I export my Charts manually by right-clicking on the specific
chart.

~ Brock

[Brock-15]

Jon,

Thanks for your quick response.  As far as the tables, that is awesome, I
did not know that was an option.

In terms of charts, do you know if it is possible to 'move' the data for a
chart and place it in the datasheet for the chart in Powerpoint? Obviously
the images of the charts from SPSS are fine, but I have been approached on
a number of occasions and asked to make it so the charts can be edited.

Thanks,

` Brock

[Peck, Jon]

Possible, yes.  Easy, not really.  Useful, maybe.

 

If you export to Word, you can edit the picture and move the segments around, which you cannot do with the ppt chart, but you can’t get at the underlying data.

 

In order to get the exact data going into the chart, you would use OMS to capture the chart, which is best done with XML format, and then use XML tools such as Xpath to extract the data.

 

oms select charts

/destination format=oxml outfile="c:/temp/chart.xml".

 

* Chart Builder.

GGRAPH …

omsend.

 

The data in a bar chart, for example, might look like this:

<embeddedSource id="graphdataset">

<names>MEAN_accel;cylinder</names>

<types>double;double</types>

<row>13.25;3</row>

<row>16.61642512077295;4</row>

<row>18.63333333333333;5</row>

<row>16.26309523809525;6</row>

<row>12.78411214953271;8</row>

</embeddedSource>

 

The schema is published on xml.spss.com and installed with SPSS.

 

It would not be hard via programmability to create an SPSS dataset from the ggraph output.  With examples like this, though, that can be done directly with Aggregate.

 

-Jon Peck

 

 

 

________________________________

From: [hidden email] [mailto:[hidden email]]
Sent: Wednesday, January 17, 2007 9:03 AM
To: [hidden email]
Cc: Peck, Jon
Subject: RE: Re: [SPSSX-L] Export to Powerpoint

 


Jon,

Thanks for your quick response.  As far as the tables, that is awesome, I did not know that was an option.  

In terms of charts, do you know if it is possible to 'move' the data for a chart and place it in the datasheet for the chart in Powerpoint?  Obviously the images of the charts from SPSS are fine, but I have been approached on a number of occasions and asked to make it so the charts can be edited.

Thanks,

` Brock