I want to make a chart where I use calculated cells. However when the
cell is empty, or should be, it is treated as 0 and shows the 0, instead
of showing nothing, like a REAL empty field.

The calculation I use is (for example) =IF(A1,A1,"")
So if A1 shows something, it will show the content. If not, it shows
nothing.

To be more specific. I put numbers in A1 to A6, exept for A3, which I
leave empty. In B1 to B6 I put the calculation. When I now use B1-B6 for
a graph, I see as if A3 is 0, not as if it were empty.

How can I see to it that it is seen as empty and thus not used in a
chart. When I leave B2 empty, it does not show in the chart as it should
be.

houghi
--
You tried, and you failed, so the lesson is, never try. - Homer J. Simpson.