Originally Posted by
jasperdog
This is no solution at all when the desired blank sections of a plot are the result of complex formula calculations! You really want me to manually select a few hundred cells every time I want a gap in my plot? I can't believe that after searching the internet for hours, every "Excel expert" gives the same stupid answers that don't work, ("Use na() blah, blah, blah"). This is a serious defect in Excel that Microsoft apparently refuses to fix.
The fact is, Excel is incapable of placing gaps in line plots where data is invalid or incalculable.
Bookmarks