Graphs - Formula in source data outputs "" to override errors - ruining graphs

File attached...

So My formula in the source data has an if function which outputs "" to override ugly na errors.

Unfortunately this means my graphs plot zero data for these points when I would prefer they would just be blank, as is the case when it is left as an error functions.

In the end I have to delete the formula in all the cells in order to make the graph look nice.

BTW i am using Excel 2003 unfortunately,

You could change the formula in C17 to this:

=IF(C16="error",NA(),C16)

Then you could hide the error using conditional formatting, setting the font colour to the same as the background colour.

Hope this helps.

Pete

nice idea, but i should have said, the other problem is I am taking the median, which means if I don't remove the errors, i cant have the median, thanks

Well, post the formula that you are using, and indicate where the errors are likely to occur.

Pete

The formula is pulling data from an external data source via an add-in that produces #n/a n/a whenever there is no data point.

So for example it will give me:

2007 2008 2009 2010 2011 2012
#n/a n/a #n/a n/a #n/a n/a 197 201 503