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/microsoft.public.excel.charting/browse_thread/t
hread/8a933a2a5da429ec/41ba3b40690f2c57?hl=en&lnk=st&q=plot+empty+cells+excel+20
07#41ba3b40690f2c57

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

Thanks

Chris