Empty cells plotted as zero.

ColinC · #1 01-23-2012, 07:01 AM

I have created a chart from 3 columns of data.
Two columns are complete, one column is built up gradually from data on another sheet. (Sheet 1)
All data is plotted correctly but an empty cell is treated as 0 and not ignored as I would like.

How can I get round this?
This is the function I am using in the incomplete column.

=IF(Sheet1!E2>0,Sheet1!E2,"")

Colin Legg · #2 01-23-2012, 07:39 AM

Hi Colin,

Try this:

=IF(Sheet1!E2>0,Sheet1!E2,NA())

because #N/A errors should be ignored.

ColinC · #3 01-23-2012, 08:02 AM

Thanks Colin. Just what I wanted.
Colin

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vba, Is there a better way to test empty cells?	Hwyn	Excel Programming	2	11-14-2011 11:44 AM
Empty rules	rene.kamphuis@ciz.nl	Mail Merge	21	04-15-2011 12:34 AM
Shared Calendar Empty	worksmart	Outlook	0	01-21-2011 06:32 AM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM
Populate an empty .PAB file	imported_contiw	Outlook	2	08-17-2006 08:50 PM