The chart has 2 series in it, one of which will always be empty. The chart itself seems to work ok.

The data I'm using is of the form:

AB

A

B

A*B (calculated in a cell)

Sometimes AB is known directly and can therefore be plotted directly. However, other times A and B are known individually. I then have another row to calculate the product of A and B.

So my two dynamic ranges are AB and A*B.

The problem is that when I know AB (and so A*B is empty) I get that stupid error when excel tries to plot the empty series?

The formula I'm using for A*B is of the form =IF(F18*F19/1000=0,"",F18*F19/1000)

Any help would be great!