View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ojv[_2_] ojv[_2_] is offline
external usenet poster
 
Posts: 53
Default 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