Login  Register

Multiple line graphs using 15

Posted by Lemon, John S. on Apr 10, 2007; 12:15pm
URL: http://spssx-discussion.165.s1.nabble.com/Multiple-line-graphs-using-15-tp1074979.html

I am trying to help a student graph the following data and I cannot see
the correct way getting a multiple line graph with two y axis. The data
represents the value of the stock exchange ( FTSE ) and of a number of
different firms and the idea is to see whether interactions between the
value of the FTSE and takeover bids affected the different firms. I can
use the legacy dialogs to create a chart with all the lines on the one
graph - but because the FTSE has a much higher value the information for
the firms is 'squashed' down at the bottom. Deally I would like the FTSE
to be on one X-axis and the firms on another. In both cases using the
optimum scaling to avoid the 'squashing'.
 
Date            ftse       firm1   firm2    firm3    firm4
01.01.2003 1893.76 391.00 452.50 305.78 360.00
02.01.2003 1923.58 391.50 457.50 310.42 364.00
03.01.2003 1923.75 399.50 465.50 310.42 369.00
06.01.2003 1921.53 408.00 465.50 302.95 368.50
07.01.2003 1903.19 402.00 464.50 301.40 366.00
08.01.2003 1888.31 398.00 463.50 298.82 356.00
09.01.2003 1892.90 392.00 469.50 297.79 361.50
 
I'll keep experimenting but I cannot see how to get chart builder to
accept two y axis !!
 
Best Wishes and thanks
 
John S. Lemon
DIT - University of Aberdeen
Edward Wright Building
<http://www.abdn.ac.uk/central/vcampus/kings/edward.shtml> : Room G51
Tel:  +44 1224 273350
Fax: +44 1224 273372