Making a Blank Cell

  • Thread starter Thread starter Confused Slug
  • Start date Start date
C

Confused Slug

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
 
Back
Top