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

Macro to loop through a named range, ignoring empty cells 1
Data in cells not visible 1
How do I stop chart from plotting null values as zeros in excel 20 3
Simple Module for Excel 2007 in VBA 6
create blank/empty cell - don't want a zero to be plotted in chart 6
Row/Column unhide shortcut keys not working in excel 2007 1
How to Prevent Blank Cells from plotting in Excel Charts? 0
scatter chart with gaps in series (XL 2007) 7

Top