Charts putting in zero values

File attached,

Hi, does any body have a good way of preventing my chart from plotting zero values for the yellow line for the years 200 to 2003?

Thanks so much folks,

You can replace those zeros with this:

=NA()

which will return #NA instead and this will be ignored by your graph.

Hope this helps.

Pete

I was afraid you would say that! so I guess I will run an if(iserror,na(),...) does that seem the best way to you? I am using Excel 2003, do future versions of excel also have this stupid problem with the charts, thanks,

Well, your profile says Excel 2010, but yes, it applies to later versions as well.

Pete