I am displaying monthly data in a simple line chart. When the data in the
assoicated cells (say for april onwards) is completely blank (not data or
equation in the cell) the line on the chart stops at march (this is the
effect i need).

However, the data in the cells is not typed in but calculated from other
cells. With the presence of the formuae the chart automatically assumes that
the value for the month of april onwards is zero even if the cell value has
been set by the formuea to equal "", causing the lines to drop to zero.

Is there any way set a cell value to 'blank' so that it does not chart? or
to format the chart?

Set the result of your formula to NA(), not to ""
--
David Biddulph

"Confused Slug" wrote in message
...
I am displaying monthly data in a simple line chart. When the data in the
assoicated cells (say for april onwards) is completely blank (not data or
equation in the cell) the line on the chart stops at march (this is the
effect i need).

However, the data in the cells is not typed in but calculated from other
cells. With the presence of the formuae the chart automatically assumes
that
the value for the month of april onwards is zero even if the cell value
has
been set by the formuea to equal "", causing the lines to drop to zero.

Is there any way set a cell value to 'blank' so that it does not chart? or
to format the chart?

This will only omit the point, but it will not leave a gap. We have asked
for several versions for a worksheet function that mimicked a blank cell,
but thus far none is forthcoming.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Set the result of your formula to NA(), not to ""
--
David Biddulph

"Confused Slug" wrote in message
...
I am displaying monthly data in a simple line chart. When the data in the
assoicated cells (say for april onwards) is completely blank (not data or
equation in the cell) the line on the chart stops at march (this is the
effect i need).

However, the data in the cells is not typed in but calculated from other
cells. With the presence of the formuae the chart automatically assumes
that
the value for the month of april onwards is zero even if the cell value
has
been set by the formuea to equal "", causing the lines to drop to zero.

Is there any way set a cell value to 'blank' so that it does not chart?
or
to format the chart?