charting not applicable data

Question

I am looking for some information about the best way to show month to month performance, on one graph for multiple departments.

A line graph seems to be the most useful manner to display the information (over bar charts, scatter charts etc).

However, there are several instances when the answer to the calculation is n/a.  The line chart plots this as 0.  0 is a possible response.

A simple solution is to change the formula so that n/a = a negative number (as negative is not a possible answer to the mathematical equation).  Then, it will plot negative and I will just need to describe that on my charts.

I don't particularly care for that and was hoping for a better solution.

Any thoughts?

Answer 1

I am a little bit confused here. A graph will not plot a Zero for a formula returning #N/A (I beleive it is the same in 2007. I can not test as we are still running 2003 at work). It will leave it blank. The only thing I can think of is that you have the Text n/a and you are plotting that on a graph. Assuming that you have a formula and the graph is not based directly off of data enetered by the user then have the formula return #N/A.

---

If this post answers your question, please mark it as the Answer... Jim Thomlinson

Answer 2

Thank you so much!  the formula was and if error return "n/a"   I set to #N/A and it skips that month.

Thank you!