SPSS AnswerNet: Result 

Solution ID:	 	100001374	
Product:	 	SPSS Base 	
Title:
LINE GRAPH with labeled points 
Description:
Q. 
I am having a terrible time getting SPSS to do the following chart. 
I would like a simple line graph with variable means with the mean 
value at or below the point. 
A. 
This is quite difficult to do. First, you will have to restructure 
the data from the form ID V1 V2 V3 .. etc. into a file with the 
structure listed below. Note that the variable VAR is exactly duplicated 
for each TAG value. Then, create the line graph as a multiple 
line graph. Edit the chart by modifying one of the lines into a bar 
(by using the Series menu item and selecting Displayed). Then, 
you must request bar labels. There is an icon in the SPSS Chart 
Editor that looks like two little gas pumps. Click on that, and 
you may select either Standard or Framed. Finally, change the color 
of the bars so that both the fill and border colors for the bars 
are White. 
This is an example of what the restructured data will look like. 
I var tag ID 
1 V1 1 1 
2 V2 1 1 
3 V3 1 1 
1 V1 2 1 
2 V2 2 1 
3 V3 2 1. 
** Here is the sample job to show how to create the chart. 


DATA LIST FREE / V1 V2 V3. 
BEGIN DATA 
2 1 6 7 7 8 6 8 7 6 8 7 3 6 8 7 6 7 8 6 2 1 7 8 6 7 8 6 
8 7 6 3 4 8 7 6 8 7 6 7 8 2 1 6 7 8 6 7 8 6 8 7 6 3 3 2 
2 1 8 7 6 8 7 6 7 8 6 3 8 7 6 8 7 6 8 7 2 3 4 3 2 1 3 2 
END DATA .
 
VECTOR V=V1 TO V3. 
LOOP I=1 to 3. 
COMPUTE VAR=V(I). 
XSAVE OUTFILE 'TEMP.SAV' / KEEP I VAR. 
END LOOP. 
EXECUTE. 

SELECT IF $CASENUM = 1. 
FLIP VARIABLES = V1 TO V3. 
AUTORECODE CASE_LBL /INTO I. 
SAVE OUTFILE 'VARNAMES.SAV' . 

GET FILE 'TEMP.SAV'. 
SORT CASES BY I . 
MATCH FILES / FILE=* / TABLE='VARNAMES.SAV' /BY I. 
COMPUTE TAG=1. 
EXECUTE. 
ADD FILES FILE=* / FILE='TEMP.SAV'. 
RECODE TAG (SYSMIS=2). 
GRAPH 
/LINE(MULTIPLE) MEAN(var) BY i BY tag 
/MISSING=REPORT.