🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Thread View: comp.apps.spreadsheets
3 messages
3 total messages Started by Ralph Treitz Thu, 07 Jan 1993 09:48
Excel 4.0 graphics
#320
Author: Ralph Treitz
Date: Thu, 07 Jan 1993 09:48
26 lines
1066 bytes
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. 

Any quick hint ?

Thanx / Ralph

-- 
-- Ralph Treitz  ( rt@sap-ag.de )  -------  c/o  S.A.P. AG  ------------------
   Phone:  +49 6227-34-1641                 Max-Planck-Str. 8
   Fax:    +49 6227-34-1880                 D-6909 Walldorf/Baden (Germany)
Re: Excel 4.0 graphics
#321
Author: A.D.Bailey
Date: Thu, 07 Jan 1993 15:38
19 lines
1066 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.
>
 [stuff deleted]
>
>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. 
>
>Any quick hint ?
>

Sounds to me like you are generating the wrong sort of graph.
Try an XY (scatter or line) plot instead of a column plot.
Try to read TFM and understand the difference between a
CATEGORY axis and a VALUE axis.
Good Luck.
Re: Excel 4.0 graphics
#322
Author: 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!
Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads