Thanks, JKpeck. My apologies for this late response
My work flow follows:
(i) Collect data from database. SPSS gets these from Oracle.
(ii) Create cross tabs within SPSS (Tables).
(iii) Export cross tabs to Excel.
(iv) In Excel, design charts for each table.
(v) In Ppt, paste Excel charts as links
(vi) In Ppt, edit design features.
My answers to your questions:
1) Are you using Ppt as a data entry forms system?
2) What happens to the data after they are edited in Ppt?
Today, nothing. Its common to aggregate different variables as a new
variable. This is done in Excel whenever there are only 2 simple
variabels, but on more complex situations, SPSS is used to create new
Other example includes performing t-tests (SPSS), and charting colored
arrows close to bars where there are differences between 2 rates (PPT).
3) Do you send them back to SPSS for statistical analysis?
Im not sure I fully understand your statement
"If it is output you are passing through, again, SPSS can save this in
various formats via the OMS syntax mechanism or with the scriptable
Viewer Export mechanism. The latter can write directly to Excel or Ppt
And with SPSS 14, you can drive the Viewer exports from PROGRAM syntax
using the viewer module on the SPSS Code Center. "
It would be great to create custom charts (defining colors, types etc)
from a scriptable way within SPSS.