Re: Multiple line graphs using 15

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

ViAnn

Thanks for your help.

The student wants the date to be the X-axis, FTSE to be the 'left' Y
axis and all the firms to appear as multiple lines on the 'right' Y
axis. If you look at http://www.abdn.ac.uk/~com045/multlines.pdf then
you can see the current graph obtained with the legacy dialog but the
effect of the greater value for FTSE prevents the trends for the forms
being seen.

Best Wishes

John S. Lemon
DIT - University of Aberdeen
Edward Wright Building: Room G51
Tel:  [phone]
Fax: [phone]

> -----Original Message-----
> From: Beadle, ViAnn [mailto:[hidden email]]
> Sent: Tuesday, April 10, 2007 12:31 PM
> To: Lemon, John S.
> Cc: [hidden email]
> Subject: RE: Multiple line graphs using 15
>
> I'm not sure how you want to divvy up the axes here. What
> goes on y1, y2, and x. You mention lines. Do you want those
> elements for y1 by x and y2 by x? You have to have two
> elements for a dual y chart and there are some restrictions
> on the types of aggregation for each set. More details please.
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]]
> On Behalf Of Lemon, John S.
> Sent: Tuesday, April 10, 2007 6:15 AM
> To: [hidden email]
> Subject: Multiple line graphs using 15
>
> 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:  [phone]
> Fax: [phone]
>
>
>