🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.mac.apps
Article #7432

Re: plotting A vs. B,C in Excel

#7432
From: Stig-Arne Nordin
Date: Fri, 22 Feb 1991 12:39
26 lines
1859 bytes
It's easy to make scientific charts with Excel 2.2, i.e. charts with values
running on the x-axis.

Excel is promoted as the businessmans and administrators spreadsheet and 
folks like us have little or no use for a value axis. At least that's what
the people at Microsoft seems to believe. I use this feature a lot.
 
Preliminaries: Open Excel. Close all windows. Make new chartdoc. 
This will be blank.In Gallery select scatter or line. In GALLERY select 
chart prefs. Close window. 
This manuever sets the scene (Default) for scientific diagrammes. It can be 
omitted but is useful if you intend to make a lot of scientific diagrammes.

Create your data set in Excel. Select and copy this data. Make new Chartdoc.
This will be blank. Chose PASTE SPECIAL! A dialog box appears. It has three
checkboxes below two radiobuttons. Check the upper two boxes and OK. Voila!
I use the swedish version of Excel. Translations of Excel commands into
swedish defy my vocabulary. Experimenting with these options can give
interesting results.

This feature in Excel is not covered by the manual for version 2.2.
I don't know 'bout earlier versions. I suppose that this works equally well 
for those; no note was added about changes in the ways these menues 
and dialogs work when 2.2 came along.
 
This is not what you could call a transparent feature.
Technical Details
Message-ID: <1991Feb22.123950.9769@fy.chalmers.se>
Path: arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!wuarchive!zaphod.mps.ohio-state.edu!rpi!uupsi!sunic!chalmers.se!fy.chalmers.se!stigarne
References: <798@sousa.enet.dec.com> <616@6sceng.UUCP>

Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!wuarchive!zaphod.mps.ohio-state.edu!rpi!uupsi!sunic!chalmers.se!fy.chalmers.se!stigarne
From: stigarne@fy.chalmers.se (Stig-Arne Nordin)
Newsgroups: comp.sys.mac.apps
Subject: Re: plotting A vs. B,C in Excel
Message-ID: <1991Feb22.123950.9769@fy.chalmers.se>
Date: 22 Feb 91 12:39:50 GMT
References: <798@sousa.enet.dec.com> <616@6sceng.UUCP>
Organization: Chalmers University of Technology, G|teborg, Sweden
Lines: 26