🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.apps.spreadsheets
Article #322

Re: Excel 4.0 graphics

#322
From: fahole
Date: Thu, 07 Jan 1993 20:09
29 lines
1485 bytes
In article <4381@sapwdf.UUCP>, ralph@sapwdf.UUCP (Ralph Treitz) writes:
> I'm not able to find anything in TFM of Excel about the right scaling of
> graphics.
> 
> What I wanna do is :
> 
> I have two coloumns		1	10
> 				2	20
> 				3	30
> 				4	40
> 				10	100
> 				20	200
> 				...     ...
> 
> Going to paint a diagramm Excel takes the first coloumn to be x but uses 
> equal space between each x-axis value. Thus the space for 1 - 2 is equal
> to the space between 10 - 20 which I would like to see correct according to 
> size of x-axis values. 

If you select these two columns and then select file, new, chart from the
menu you will get a question asking if the first coulumn is catagory labels,
the first data series, or x-axis values.  If you select catagory labels you 
will get the chart you are getting.  If, however you select x-axis values,
you will get an x-y plot and not a line plot.  This will make the distance
between the values on the x- axis relative to their numerical value.
-- 
David Hole                  DHOLE@MENDEL.USU.EDU
Utah State University       FAHOLE@CC.USU.EDU
Logan, UT                   Just say snow!
Technical Details
Message-ID: <1993Jan7.140932.62534@cc.usu.edu>
Path: arc1-ca.pugleaf.net!sparky!uunet!caen!hellgate.utah.edu!cc.usu.edu!fahole
References: <4381@sapwdf.UUCP>

Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!caen!hellgate.utah.edu!cc.usu.edu!fahole
From: fahole@cc.usu.edu
Newsgroups: comp.apps.spreadsheets
Subject: Re: Excel 4.0 graphics
Message-ID: <1993Jan7.140932.62534@cc.usu.edu>
Date: 7 Jan 93 14:09:31 MDT
References: <4381@sapwdf.UUCP>
Organization: Utah State University
Lines: 29