Generating blank cells in Excel 2007

  • Thread starter Thread starter ChrisBowringGG
  • Start date Start date
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
 
Hi Chris

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