Plotting blank cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Surpressing plot of blank cells 3
Chart error: plotting series data XY scatter plot 3
clear formula that does not return a value automatically? 4
Concatenate a row that is selected and include blank cells 11
How do I exclude a cell from a range? 4
Plotted data changes in XY Plot if first cell is in X data is blan 1
Urgent help on plotting a X,Y graph... 2

Back
Top