GraphMaT version 2.21 Addendum to GRAPHMAT.TXT and User's Guide Feb. 24, 1997 ---------------------------------- Spreadsheet Compatibility (page 5) ---------------------------------- * Excel 7 for Windows '95 GraphMaT has been tested with Excel 7 for Windows 95. The macros run as in Excel 5 for Windows 3.1. However the XY graphs created using Lotus keystrokes or macros are displayed incorrectly due to a problem in Excel 7. The graphs have what appears to be a line type graph axis and no data points appear on the graph. If you have Excel 7 and want to try GraphMaT, you can run the macro. After it is finished, save the file. Then close the file and reopen it. Select the graph and choose Format Autoformat. Then select XY(scatter) and select one of the scatter graph formats displayed. The autoformat will redefine the axis correctly and display the points. Since GraphMaT does display the graphs correctly in Excel 8 for Office '97, it is therefore recommended that GraphMaT not be used with Excel 7 and that you upgrade prior to testing GraphMaT. * Microsoft Office 97 (Excel 8 for Windows '95 or Windows NT) GraphMaT has also been tested with version 8 of Excel which is a part of Microsoft Office 97. The problem noted with version 7 has been corrected, however two problems which affect GraphMaT were encountered. Both have been addressed in version 2.21 of GraphMaT. The first problem is that user menus which contain a formula were improperly displayed. These menus were replaced in version 2.21 of GraphMaT. The second problem is that when combining named ranges, Excel 8 only brings in cells from column A. This is a more serious problem for GraphMaT since it uses this operation to bring the macro code into 0GRAPH.WK1 from the GRAPH.MAT file and to bring in data in some tutorials. This problem can be circumvented by using the cell addresses instead of the range name.  1. To start a new macro using 0GRAPH.WK1 select the User graph and enter the cell address for the desired macro when prompted for the name of the macro. The addresses from the macros in GraphMaT version 2.21 are given the table below. For example, to start the macro to solve simultaneous equations in Tutorial 1 (page 27), type [Alt+G] New User A391.T422 [Enter] This is the equivalent of making the following selection from the menus. [Alt+G] New Function Simultaneous Macro Address ----- ------- REG A51.U88 LLD A91.U128 MULT A131.T151 NORD A161.T189 CFIT A191.W218 XREG A221.U297 YFX A311.U350 GX A351.U390 SIMUL A391.T422 EQN A451.T491 PLOT A501.X556 TRAN A561.T669 These addresses have been programed into 0GRAPHXL.WK1 so that the macros can be started as shown in the GraphMaT User's Guide. However, if a file created from this file is used with a different version of GRAPH.MAT it may not work properly. 2. When using the Combine options during a macro or when using the GraphMaT utility macro, specify cell addresses instead of the range name if the data is not all in column A. Starting with rev 2.21 of GraphMaT, wherever possible the sample files are arranged so column A contains all the data. In two cases data points for several variables are combined simultaneously. For these use the cell addresses given below instead of the range name. Page Range name Cell addresses File name ---- ---------- -------------- ------------ 37 DATA B2.J28 NBASTATS.WK1 54 IND B193.F212 SAMPLES.WK1