Thread
:
How to make Excel Chart not to display empty cells?
View Single Post
#
2
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc
Kelly O'Day
Posts: n/a
How to make Excel Chart not to display empty cells?
Marko:
In your If statement, replace "" with Na(). Excel will place a #N/A in the
cells that were getting the "". Excel charting recognizes #N/A and will not
go to 0.
See this post for more details.
http://processtrends.com/pg_charts_missing_data.htm
...Kelly
"Marko Pinteric" wrote in message
...
I have a range of IF formulas. Sometime IF returns number, sometimes "".
The problem is that chart displays "" as value 0. Is there a way
to force chart not to display those empty values?
IF(condition; number_value; "")
Marko
Reply With Quote