Line Graphs - How do I plot N/As?

Hi
I've got a bunch of simple values to plot on a line graph that range from 0-20 but also include N/As. There are several rows of this data that I'm wanting to plot as individual graphs, and sometimes they include a wide range of figures including both N/As, zeroes and proper 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 zeroes (as they do) but to appear as breaks in the line graph. Is this possible? Obviously the reason I don't want them as zeroes is because it will mix an actual result of zero, with no result at all - there is clearly a big difference!

Can anybody lend a hand?

Many thanks
duncanm

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/
_______


duncanm wrote:
> Hi
> I've got a bunch of simple values to plot on a line graph that range
> from 0-20 but also include N/As. There are several rows of this data
> that I'm wanting to plot as individual graphs, and sometimes they
> include a wide range of figures including both N/As, zeroes and proper
> 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 zeroes
> (as they do) but to appear as breaks in the line graph. Is this
> possible? Obviously the reason I don't want them as zeroes is because
> it will mix an actual result of zero, with no result at all - there is
> clearly a big difference!
>
> Can anybody lend a hand?
>
> Many thanks
> duncanm
>
>