Line Graphs - How do I plot N/As?

[duncanm]

Hi
I've got a bunch of simple values to plot on a line graph that rang
from 0-20 but also include N/As. There are several rows of this dat
that I'm wanting to plot as individual graphs, and sometimes the
include a wide range of figures including both N/As, zeroes and prope
figures (e.g. 0, 2, 5, N/A, 2, 3, 5, 0, 6, 6, 1, 4, N/A, 5, 5, 6, 3, 5
5, 0, 1, 5, etc etc).

The problem I'm having is that I want the N/As not to appear as zeroe
(as they do) but to appear as breaks in the line graph. Is thi
possible? Obviously the reason I don't want them as zeroes is becaus
it will mix an actual result of zero, with no result at all - there i
clearly a big difference!

Can anybody lend a hand?

Many thanks
duncan

 

[Jon Peltier]

If a cell contains N/A (default alignment: left), that's a piece of
text, which is interpreted as zero. If it contains the #N/A error
(default alignment: center), from an error or from a formula returning
NA(), that is plotted almost like a gap. The line extends across the
gap, connecting the points on either side of the #N/A error.

To get the interpolated approach (line spanning the gap), change the N/A
text to the #N/A error. To get a gap, look for workarounds on Tushar
Mehta's (http://tushar-mehta.com) and Andy Pope's (http://andypope.info)
web sites.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______