Thread: 0's appearing in chart, even when cell is empty
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
ALEX ALEX is offline
external usenet poster
  
Posts: 493
Default 0's appearing in chart, even when cell is empty
I have imput the following formula into cell B5 =IF('[sUMMARY
Summer.xls]Ethnic Origin (Platinum)'!$D$4<"",'[sUMMARY Summer.xls]Ethnic
Origin (Platinum)'!$D$4,NA())

What I wanted it to do was for my chart to ignore anything in this
particular cell, and not show any value, but when I do this the value on the
chart is #N/A, as opposed to 0 when I simply had the last part of the formula
above "" as opposed to NA().

What is it that I am doing wrong?
Reply With QuoteReply With Quote