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


--
duncanm
------------------------------------------------------------------------
duncanm's Profile: http://www.excelforum.com/member.php...o&userid=27240
View this thread: http://www.excelforum.com/showthread...hreadid=467859

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