Article View: comp.apps.spreadsheets
Article #322Re: Excel 4.0 graphics
From: fahole
Date: Thu, 07 Jan 1993 20:09
Date: Thu, 07 Jan 1993 20:09
29 lines
1485 bytes
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!faholeReferences:
<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