graphs and blank cells

  • Thread starter Thread starter Anne Christensen
  • Start date Start date
A

Anne Christensen

I need help to make a graph showing data in a column containing cells made
blank with =""

On the graph these blank cells represent zeros (this is when i use ="" to
make cells blank) and i want them not to be shown (on the graph) - rather
shown as a break (on the graph).

This is only a problem when the blank cells are made blank by ="". If i make
a graph showing entered numbers in a column where some are left blank i get
a graph containing breaks as i want.

This tells me that the problem may be the way i make cells blank, but i dont
know how to do it otherwise.....

thanks
 
Instead of having ="", how about using something like NA() in your formulas, eg:-

=IF(A1>4,B1,NA())

The NAs will appear as blank cells as far as your graph is concerned and will not show. If you
don't like the NAs, then you can use a conditional format to make them white (Same as the
background).
 
Hi Anne

As per definition a cell is blank, only when it contains *nothing*,
no numbers, no text, no formulae, so I believe, it's not
possible to do, what you want, but someone else might
prove me wrong.

If it's only a matter of printing the graph, you could make a
macro, which searched the cells for the value "". If found,
the cell was moved one cell to the right. When all were moved,
the graph was printed and the cells moved back to their proper
places.

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.
 
Back
Top