V
VÃtor Ferreira
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!
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!