Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!helios!bcm!dimacs.rutgers.edu!seismo!uunet!zaphod.mps.ohio-state.edu!unix.cis.pitt.edu!dsinc!netnews.upenn.edu!eniac.seas.upenn.edu!jeffe From: jeffe@eniac.seas.upenn.edu (George Jefferson ) Newsgroups: comp.sys.mac.apps Subject: Re: MS Excel Keywords: charts Message-ID: <36723@netnews.upenn.edu> Date: 31 Jan 91 22:12:42 GMT References: <6454@ecs.soton.ac.uk> <36577@netnews.upenn.edu> <1991Jan31.203753.10111@cs.umn.edu> Sender: news@netnews.upenn.edu Reply-To: jeffe@eniac.seas.upenn.edu (George Jefferson ) Organization: University of Pennsylvania Lines: 19 :> :Actually, the columns don't have to be consecutive--I used to think so as :well, but somebody on the net corrected me. You select the x column first, :and then select the other column while holding down either the option key Another neat trick, you can edit the series descriptions in chart 'mode'. Say you have an existing chart, and you want a new series with the same x 'column' as an existing one - you can select the series copy, paste, chnage the y `column` reference and now you have a new series on the chart. Excell is _almost_ useful for x/y charting. If it werent for a few stupid quirks, like the lack of a line-only scatter graph...sigh -- -george george@mech.seas.upenn.edu