Amend your formula to say NA() instead of zero.
--
David Biddulph

"Dom" wrote in message
...
Hi

I hope someone can help and that my query is possible. A bit of a long
explaination but please bare with me.

Is there away of information only showing in a graph once a certain date
has
expired. As I have a graph which updates itself monthly from another excel
sheet I use. However I dont want this information to show up until the
month
has gone so I dont want Aprils information to show up until 1st of May.
Unless I do this the line graph drops to 0 for the rest of the year and
doesnt look very good. I have been able to use an IF statement and an
error
to hide any 0's but for some graphs some of the months will say 0.

Hope that made sense I would really appreciate any help with this as I
have
no idea where to start if even possible

Thanks