BUILT-IN WORKSHEET GRAPH

_STAT.WK1 is one of the built-in Lotus worksheets found on the English language version of the 95LX. (Also archived in _HPWK1.ZIP (ON DISK)) It can display a graph of the data with a least squares regression line plotted into it. This easy graph is not easy to do from scratch. It is invoked from the worksheet by pressing (ALT)-P.

Unfortunately, the graph disappears if you press any key. I found that a simple edit of the Lotus (ALT)-P macro keeps the graph from disappearing (allowing you to edit, save, or print it).

The macro is located in cell IB7045 of _STAT.WK1. Change the macro by deleting the following 24 characters from the macro:

{R 2}/re..{END}{D}~/grgq

This sequence of characters ends 25 characters from the right end of the macro.

Since _STAT.WK1 is written in ROM, you cannot save this change to it. You may, however, save this new version of _STAT.WK1 to the C drive.

Paul Swadener Eugene, OR USA