• 0

Creating blank cells in excel

  • 0


Does anyone know how to make Excel treat a cell as blank if there is a formula in it?

I have a formula which puts the contents of one cell into another

In some cases the reference cell is blank so no value is entered into the cell.

However, when I plot a chart of this data, the empty cells are plotted as zero.

Is there a way to have the empty cells *not* plotted? As I would rather have gaps in the graph, or interpolate between missing values.

I know that if you go to tools>options>chart you can select how to represent blank cells in a chart. My problem is creating the blank cell in the first place.

Any help would be totally appreciated.




0 Answers

  1. Turns out its:

    I thought I better put the answer up in case someone else had the same problem.

    Thanks anyway!:)

    • 0