graphs and blank cells

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
 
K

Ken Wright

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).
 
L

Leo Heuser

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.
 

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

Top