Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-23-2012, 07:01 AM
ColinC ColinC is offline Empty cells plotted as zero. Windows 7 64bit Empty cells plotted as zero. Office 2010 64bit
Novice
Empty cells plotted as zero.
 
Join Date: Dec 2011
Location: England
Posts: 9
ColinC is on a distinguished road
Default Empty cells plotted as zero.

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,"")
Reply With Quote
  #2  
Old 01-23-2012, 07:39 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Empty cells plotted as zero. Windows 7 32bit Empty cells plotted as zero. Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi Colin,

Try this:

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

because #N/A errors should be ignored.
Reply With Quote
  #3  
Old 01-23-2012, 08:02 AM
ColinC ColinC is offline Empty cells plotted as zero. Windows 7 64bit Empty cells plotted as zero. Office 2010 64bit
Novice
Empty cells plotted as zero.
 
Join Date: Dec 2011
Location: England
Posts: 9
ColinC is on a distinguished road
Default

Thanks Colin. Just what I wanted.
Colin
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Empty cells plotted as zero. Vba, Is there a better way to test empty cells? Hwyn Excel Programming 2 11-14-2011 11:44 AM
Empty cells plotted as zero. 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:47 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft