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.