"Paul J. Weaver" <pjweaver@ralvm29.vnet.ibm.com> (06/26/91)
Can someone tell me if there is a newsgroup more specific to IBM DOS, where I can look for some help with using Lotus & Quattro applications ? If this is the right place, what I am looking to do is the following: I am tracking several Mutual Funds via several different worksheets. Every week I want to make a graph of their price vs. an average. For example, the first week I want to trace price vs. avg for weeks 1-10. The next week I want to track prive vs. avg for weeks 2-11, etc. What I am trying to avoid is typing in a new X, A, B, etc range for each worksheet every week. Is there some way that I can make these ranges dynamic so that I don't have to reset them every week, or else only define them once per week and use them from worksheet to worksheet ? Any help would be greatly appreciated. ---------------------------------+-------------------------------------- Paul J. Weaver | pjweaver@ralvm29.vnet.ibm.com | ---------------------------------+--------------------------------------