Hi
try changing your IF function to something liek
=IF(a1"",A1,NA())

so instead of returning " " return NA()
you may use conditional formating to hide these output (use a white
font color for this)


--
Regards
Frank Kabel
Frankfurt, Germany

I have built a simple line graph, showing last year sale figures,
this
years budget and this years actuals. I have 12 months worth of data
for the first two categories, but only two months for actuals.

The problem I have is that the data for the graph is being taken from
a table which gets its information from a larger data block using a
lookup function.

The problem I have is that the data for actuals includes a number for
January and February but nothing for March onwards. To insure that
there is nothing there I have used an if funtion to return a " " if
there is no number or the number itself if there is. The chart shows
the " " as a zero, but all I want to see is a line representing
January and February.

I know this is probably a really basic thing but I just can't find
the
answer.

HELP!!!

Thanks

Simon


---
Message posted from http://www.ExcelForum.com/