halam1@ub.d.umn.edu (Haseen I. Alam) (02/10/91)
Please do not ask me to buy another graghing program.... I could not find this on the manual. But maybe I missed it. I want to plot column A vs. some of the other columns. But everytime try this it plots all the columns vs. the row numbers. Any clues. Thanks in advance. Haseen. -- .-----------------------------------------------------------------------. | Haseen Ibne Alam | email : halam1@ub.d.umn.edu | | "LET THE FORCE BE WITH YOU." | or st0404@AppleLink.Apple.Com | `-----------------------------------------------------------------------'
stigarne@fy.chalmers.se (Stig-Arne Nordin) (02/22/91)
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.