Thread: Dynamic Chart including unwanted rows

Hi im using dynamic charts in my excel spreadsheet. They work great for all but one column. This is the formula in a named ranges that work.

Code:

=OFFSET('Column1'!$E$5,1,0,COUNTA('Column1'!$E:$E)-5,1)

The problem column is a sum value that normally returns zero because its a product of the data i want to use in the dynamic range. In the column im using this formula to hide the zeros.

Code:

=IF(N64="","",SUM(M64+I64))

When I try and use the named range as I am in those that work the formula picks up the formula not the blank cell! Is there a way to deal with that?

Thanks

Rup

Thanks where do i fit that in? Ive tried it like this

Code:

=OFFSET('Column1'!$P$5,1,0,COUNTBLANK('Column1'!$P:$P)-1,1)

Thanks

Thanks ive tried it but it still doesnt work,, ive tried to sub the -1,1 on the end with -1,0 but that isnt working either.. sorry for been thick where should i start with fault finding it?
Rup