Posted by Thomas Lotzer on February 13, 2002 9:51 AM
I'm currently using Excel 97 - but same old problem as with older versions.
I preload my formulas on the spreadsheet and drag them down 110 rows and go across columns G to AM. On a daily basis, I add new data in columns A to E and the formulas put the calculated amounts across G through AM on that specific row, but the unused rows below that appear blank (the preload formulas are there however).
I use 9 different line charts to view various data from the spreadsheet(the charts having a "y" axis of "zero to 100 by 10's", and the "x" axis goes out the 110 rows).
Now the problem. The charts identify those "invisible" preloaded formulas as a "zero" and places a line across the "unused" portion of the 110 rows of the chart at the "zero" level - I don't want anything to appear on the unused portion of the 110 rows as it is most confusing.
Does anyone have a solution to keep the unused "preloaded" formulas from being seen by the chart until the formulas turn into visible calculated amounts on the spreadsheet?