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,
Bookmarks