Hi,
For getting tables from SPSS into Word, I find if you fiddle with the options for charts in SPSS (Edit > Options > Pivot Tables tab > play around with formatting), and get the SPSS output looking how you want, it pastes across quite well into Word (2007) and only needs minimal formatting afterwards (namely table width being set to 17 so it doesn't break across the page).
The downside being you'll have to re-run the analyses with the new table settings to change the output files.
For big, whole page tables, I found pasting them to paint/paintshop/corel draw, saving them as images; inserting them into Word and just rotating the whole image works alright; so it fits as a landscape page
And Sue; thanks for the heads up on Adobe Illustrator :)
Dz
________________________________________
From: Research of postgraduate psychologists. [[log in to unmask]] On Behalf Of Elizabeth Gabe-Thomas [[log in to unmask]]
Sent: 20 January 2010 11:24
To: [log in to unmask]
Subject: Re: more on chart problems
Hi all,
One option may be to export them into a PDF, then use a program which allows you edit pdfs. There are loads of free ones that you can download on the internet.
Lizzi
Elizabeth Gabe-Thomas
PhD student /Demonstrator
School of Psychology
Link 3rd floor
University of Plymouth
Drake Circus
Plymouth
-----Original Message-----
From: Research of postgraduate psychologists. [mailto:[log in to unmask]] On Behalf Of Jamison-Powell, Susan
Sent: 20 January 2010 11:10
To:
Subject: Re: more on chart problems
Hi Caroline,
SPSS charts are currently the bane of my life! My problem with them is that they are really poor quality when copied across. Luckily I am only using box pots etc so they are pretty straightforward graphs and therefore I am duplicating them in Adobe Illustrator to a much better graphical standard.
Sorry - I don't have any alternative for you though. It would be so nice if different programs got along better!
Sue
##################
Sue Jamison-Powell
Communications Officer
Psychology Postgraduate Affairs Group
http://www.psypag.co.uk
> -----Original Message-----
> From: Research of postgraduate psychologists. [mailto:[log in to unmask]] On Behalf Of Caroline
> Wilson
> Sent: 20 January 2010 11:06
> To: [log in to unmask]
> Subject: more on chart problems
>
> I am currently finding it a chore to take tables out of SPSS output
> (mostly 16 but some earlier) and transferring them in to Word documents
> to write up my results.
> What seems to work best so far is to copy into a single cell Word table
> and fiddle about with them. I've come up with this following a mix of
> advice in Nicola Brace et al's book (SPSS for psychologists : a guide to
> data analysis using SPSS for Windows) and course I've been on about how
> to handle tables in Word.
>
> It's still incredibly fiddly - especially if you want to edit out
> columns or shrink some of the bigger tables so they'll fit on a single
> side of A4.
>
> Has anyone got any good tips or guidance you could point me to? (I've
> already tried the suggestion of transporting them via Excel but I just
> found that even more time consuming).
>
> Many thanks
>
> Caroline Wilson
> PhD student
> De Montfort University
>
|