Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
When is a cell empty and how do I empty it. | Excel Discussion (Misc queries) | |||
format a cell with a formula so an empty reference cell shows blan | Excel Discussion (Misc queries) | |||
formula, move to previous cell when the current cell=0 or empty | Excel Discussion (Misc queries) | |||
Leaving an empty cell empty | Excel Discussion (Misc queries) | |||
why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) |