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

Plotting blank cells
 

Hi ojv,
I am not certain, but I think this may have to do with how you select the
region you are plotting. If the code is not explicit and it is selected by
region, then I think it will automaticaly exclude the 0s. By explicit, I
think you will have to give the exact range ie, Range("A2:M4"). Hope this
works and addresses the problem.

"ojv" wrote:

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