Path: utzoo!utgpu!jarvis.csri.toronto.edu!clyde.concordia.ca!uunet!microsoft!neilh
From: neilh@microsoft.UUCP (Neil HOOPMAN)
Newsgroups: comp.sys.mac
Subject: Re: Excel
Summary: x by y scatter plot description
Message-ID: <51109@microsoft.UUCP>
Date: 28 Feb 90 18:56:41 GMT
References: <41993.25DF0C59@cmhgate.FIDONET.ORG>
Reply-To: neilh@microsoft.UUCP (Neil HOOPMAN)
Organization: Microsoft Corp., Redmond WA
Lines: 20

In article <41993.25DF0C59@cmhgate.FIDONET.ORG> 
Matt.Bordenet@f31.n343.z1.FIDONET.ORG (Matt Bordenet) writes:
>I have a very basic question:  when I plot figures graphically, how can I 
>get the x-axis to be a set of data (and not just 1 to XXXX incremented by 
>one.)  In other words, how can I get a graph comparing column 1 to column 
>2?

To plot a chart with x by y in Excel:

   * Select the range (2 columns with x in the first and y in the second)
   * Edit/Copy
   * File/New  Chart
   * Edit/Paste Special...  [X] Categories in first column  <ok>
   * Gallery/Scatter, type #1  <ok>

Hope that helps!

------------ Neil Hoopman - Microsoft -- uunet!microsoft!neilh ------------- 
    "Carpe Diem.  Seize the day.  Make your lives extraordinary."  - DPS
------------- Microsoft owns the keyboard.  I own the fingers. -------------