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