<?xml version="1.0" encoding="utf-8"?><!DOCTYPE article  PUBLIC '-//OASIS//DTD DocBook XML V4.4//EN'  'http://www.docbook.org/xml/4.4/docbookx.dtd'><article><articleinfo><title>FAQ/graphFAQ</title><revhistory><revision><revnumber>56</revnumber><date>2016-08-01 09:35:57</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>55</revnumber><date>2014-03-27 13:06:01</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>54</revnumber><date>2014-03-27 12:55:51</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>53</revnumber><date>2013-03-08 10:17:12</date><authorinitials>localhost</authorinitials><revremark>converted to 1.6 markup</revremark></revision><revision><revnumber>52</revnumber><date>2013-02-18 11:41:58</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>51</revnumber><date>2013-01-22 16:50:58</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>50</revnumber><date>2012-07-10 15:01:16</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>49</revnumber><date>2012-07-10 09:20:21</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>48</revnumber><date>2012-05-21 12:58:23</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>47</revnumber><date>2012-05-03 15:17:11</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>46</revnumber><date>2012-02-21 14:45:31</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>45</revnumber><date>2012-02-16 17:34:09</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>44</revnumber><date>2012-02-16 17:30:18</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>43</revnumber><date>2012-02-16 10:26:34</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>42</revnumber><date>2012-01-17 14:49:53</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>41</revnumber><date>2011-01-21 10:27:44</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>40</revnumber><date>2011-01-21 10:12:53</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>39</revnumber><date>2010-10-12 12:06:02</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>38</revnumber><date>2010-10-11 12:01:43</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>37</revnumber><date>2010-06-15 14:34:04</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>36</revnumber><date>2010-06-15 14:32:24</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>35</revnumber><date>2010-04-23 14:26:09</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>34</revnumber><date>2010-04-23 14:25:10</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>33</revnumber><date>2010-03-17 15:59:28</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>32</revnumber><date>2010-03-17 15:59:13</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>31</revnumber><date>2009-12-14 16:17:17</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>30</revnumber><date>2009-09-03 14:59:35</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>29</revnumber><date>2009-08-24 14:29:08</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>28</revnumber><date>2009-06-10 12:21:12</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>27</revnumber><date>2009-06-10 12:09:20</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>26</revnumber><date>2009-05-15 14:25:38</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>25</revnumber><date>2009-04-29 12:23:35</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>24</revnumber><date>2009-04-29 11:52:52</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>23</revnumber><date>2009-04-24 13:50:00</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>22</revnumber><date>2009-04-08 11:08:16</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>21</revnumber><date>2009-02-18 10:17:10</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>20</revnumber><date>2009-02-18 10:09:36</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>19</revnumber><date>2008-10-24 10:16:23</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>18</revnumber><date>2008-01-08 15:54:39</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>17</revnumber><date>2008-01-08 15:53:16</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>16</revnumber><date>2007-10-25 16:49:35</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>15</revnumber><date>2007-07-26 09:34:30</date><authorinitials>IanNimmoSmith</authorinitials></revision><revision><revnumber>14</revnumber><date>2007-06-19 10:21:05</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>13</revnumber><date>2007-06-19 10:20:46</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>12</revnumber><date>2007-06-08 10:28:19</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>11</revnumber><date>2007-06-08 10:12:03</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>10</revnumber><date>2007-06-05 14:22:29</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>9</revnumber><date>2007-04-27 09:08:44</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>8</revnumber><date>2007-02-21 13:06:34</date><authorinitials>devel03.mrc-cbu.cam.ac.uk</authorinitials></revision><revision><revnumber>7</revnumber><date>2007-02-21 13:06:26</date><authorinitials>devel03.mrc-cbu.cam.ac.uk</authorinitials></revision><revision><revnumber>6</revnumber><date>2007-02-21 11:22:04</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>5</revnumber><date>2006-10-24 15:45:10</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>4</revnumber><date>2006-10-19 15:31:47</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>3</revnumber><date>2006-09-29 13:25:25</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>2</revnumber><date>2006-09-28 15:18:25</date><authorinitials>PeterWatson</authorinitials></revision><revision><revnumber>1</revnumber><date>2006-09-28 15:18:13</date><authorinitials>PeterWatson</authorinitials></revision></revhistory></articleinfo><section><title>Questions about graphics</title><orderedlist numeration="arabic"><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/excmac#">Why do I get a NAME? appearing in cells when I try to run an EXCEL spreadsheet program?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/split#">How do I split comma delimited data occurring in a single cell into separate columns in EXCEL?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/ref#">How do I make bibliographic citations of a SPSS or R procedure?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/screen#">How do I copy a SPSS window into a document?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/compute#">Why does SPSS give me a file definition error message when I run syntax?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/SPSSout#">How do I get my SPSS output file to open in a new version of SPSS?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/stars#">Why does SPSS give a row of asterisks instead of a mean in the outputted pivot table?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/emailSpo#">How do I e-mail an SPSS output file?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/port#">How do I e-mail a SPSS data file created on a PC so that it is readable on a MAC (and vice-versa)?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/spsssas#">How do I read a SPSS data file into SAS?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/Rin#">How do I read R syntax code into a R session and obtain primers on other issues to get started with R?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/Rpackin#">How do I download R libraries?</ulink> </para></listitem><listitem><para><ulink url="http://www.harding.edu/fmccown/R/">A primer on producing plots (and pdf copies) in R.</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/Ratomic#">How to avoid &quot;$ operator is invalid for atomic vectors&quot; in R</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/pdfs#">How do I convert a Microsoft file application (e.g. powerpoint) into a pdf file?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/sumifs#">How do I recode ACE-R scores (prior to summing) in EXCEL?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/ExcelErrorBars#">How do I put error bars on EXCEL bar and line graphs?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/SPSSErrorBars#">How do I produce interaction plots in SPSS?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/ExcelErrorBarPlot#">How do I plot boxplots in EXCEL?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/points#">How do I scatterplot observations which have the same set of co-ordinates?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/lines#">How do I do a multiple line plot of cluster profiles for different factors in SPSS?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/faq/excelplot#">How can I distinguish groups on a scatterplot in EXCEL?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/bar#">How do I produce a bar chart including one with empty categories and other features in SPSS?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/barpercent#">How do I produce an interactive bar chart of percentages in SPSS?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/regline#">How do I put one or more regression lines on a scatterplot in SPSS Version 12.0 and above and in R?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/reglineR#">How do I plot user defined regression lines (such as those from ANCOVA) in R?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/box#">How do I produce a clustered boxplot and other more advanced graphics in SPSS?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/pdfword#">How do I convert a pdf file into a MSWord or MSPowerpoint file?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/ppts#">How do I convert a powerpoint show file so it can print handouts?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/pphttp#">How do I activate a hypertext link in powerpoint?</ulink> </para></listitem><listitem><para><ulink url="https://lsr-wiki-02.mrc-cbu.cam.ac.uk/statswiki/FAQ/graphFAQ/statswiki/FAQ/toolkit#">How do I add in the analysis toolkit (and other add-ins) into EXCEL?</ulink> </para></listitem></orderedlist></section></article>