I'm getting the error above for a chart.
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!
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!