Dynamic Chart will not work as empty cells contain Formulas

Hi all,
I have created a dynamic chart using offset and counta formulas in the range, but because there is a forumla feeding the blank cell, excel reads it as populated and hence shows all the cells the x axis.

How do I get rid of the x axis populating when there is a formula in the cell?
so for instance "Drivers!H10" will populate with a number from 0-50 I only want the chart to show anything on it if the number is one or greater.
so I wrote this on the pickup cells in the range.

=IF(Drivers!H10=0,(""),(Drivers!H10))

The problem is the chart still registers that as a space on the x axis?

thanks again guys, this site has been great, saved me many hours of headbashing!!

James

Extend your counta formula to include a subtraction of those cells =""

COUNTA(A1:A6)-COUNTIF(A1:A6,"")

Assuming your data is in A1:A6