Plotting blank cells
I'm plotting ranges which may or may not include blank cells in the first few
cells. Using the statement
ActiveChart.DisplayBlanksAs = xlZero
has no effect whatsoever, Excel shrinks the plotted range to exclude any
blank cells at start of range. What am I doing wrong? Any help appreciated.
Using Win XP
|