Hi,

I am trying to setup a dynamic chart in excel which may include data from 2 cells up to 2,000 or so.

This on itself is not a problem, the problem occours becuase the x-axis cell has this formula in it:

=IF(A18<$Z$4,A18+1,"")

And the y-axis

=IF(A19=Z4,"",B18*SUM(interest))

If the cell comes up as false and the "" is entered in, the COUNTA function does not record this as a blank cell and thus does not ignore the data. Making a traditional dynamic chart approach useless.

A solution I thought up on my own is to use a ADDRESS function to get the end of the data set I require and somehow try and get excel to update from this automatically.

For example at the moment the data goes from:

$A$19
$A$90

And if I change a few things the data now runs from:

$A$19
$A$1578

This calculation I can make happen automatically but excel will not take it as source data, but insteads trys to graph the two cells not the result of the forumla which gives a range of 1559 cells. Even if I put in the source data =ADDRESS(19,1):ADDRESS($Z$4+18,1) or so on it still will not take it.

Anyone have any ideas how to solve this problem?