Thread: Empty Cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vítor Ferreira Vítor Ferreira is offline
external usenet poster
 
Posts: 1
Default Empty Cell

Hi all,
I have a problem with graphic presentation once it presents a line where it
should be nothing. To be honest the real problem is with my graphic data
source, that's because on my source column i'm using a formula like
"=IF(A1="";"";A1)" and when i get no value ("") the graphic present it as 0.
But if in those cells where the value is "" i delete the formula, then my
graphic presents nothing, exactly what i wanted once is nothing there. For
what i understand that's because Empty cells and Blank cells are two
different things, and the "" is a blank cell. My question is, is there any
way to make that cell empty? Something like "IF(A1="";EMPTY;A1)".

Thanks!