How to fix dynamic chart data error

[kelly mort]

Hi I have these formulas I am using to plot my charts to keep track as the data expand and shrink .

=Offset(DataSheet!$B$2,,,CountIf(DataSheet!$B$2:$B$12,"<>"))

=Offset(DataSheet!$C$2,,,CountIf(DataSheet!$C$2:$C$12,"<>"))

It's working great just that when the cell B2 or C2 becomes blank, it throws a formula error.

How do I fix this?

I need a way to suppress that alert while being able to perform calculations.

I am actually looking for any cooler solutions.

Thanks