Generating blank cells in Excel 2007

C

ChrisBowringGG

Hi

I'm creating graphs in Excel 2007 and my ranges contain cells that can
be empty.

The ranges contain cells with formulae that sometimes need to return
blanks. I've done this using "" (two double quotes).

Unfortunately, Excel charts do not recognise a cell with "" as blank,
and will plot these cells as zero. See following link for description
of charts and empty cell plotting:

http://groups.google.co.uk/group/mi...=plot+empty+cells+excel+2007#41ba3b40690f2c57

Is there a way of simulating a blank cell with a formula?

Thanks

Chris
 
R

Roger Govier

Hi Chris

Instead of using "", use NA().
Charts will ignore cells with (NA) and will not treat them as zero values.
 

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

Surpressing plot of blank cells 4
Blank instead of "" 5
Formula'd cells charting as zero values 3
set cell to empty 1
create blank/empty cell - don't want a zero to be plotted in chart 6
Graphing with "Empty" vs "Blank" Cells 2
How to create a formula that results in a blank cell if required 7
graphing data only in a certain range 2

Top