software

In an all-line chart, #N/A valies are not shown ... highly useful for showing
an incomplete line.
However, in a combination chart (third data type is a line, displaying to
the secondary axis) this does not happen, and #N/A values are being treated
as zeros. Any ideas on what I can do to make the line truncate???
Thanks in anticipation!
--
Bernard

In my combo chart, the line on the secondary axis treated #N/A as expected,
by interpolating across the missing value. Make sure what looks like quot;#N/Aquot;
is really the NA error, and not a bit of text that mimics the error.

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

quot;Bernard Harrisquot; lt;bernard@Reading_UKgt; wrote in message
...
gt; In an all-line chart, #N/A valies are not shown ... highly useful for
gt; showing
gt; an incomplete line.
gt; However, in a combination chart (third data type is a line, displaying to
gt; the secondary axis) this does not happen, and #N/A values are being
gt; treated
gt; as zeros. Any ideas on what I can do to make the line truncate???
gt; Thanks in anticipation!
gt; --
gt; Bernard