Dynamic Range Excluding "" Values Returned from Formula

[slash_gnr3k]

Hi there,
I have a list of values as below

AB
Text1 1
Text2 3
Text3 10
Text4 19

The user defines this list in column A in another sheet and can add or delete values.

Column A returns the values as a result of the fomula :

Please Login or Register  to view this content.

which prints out a blank value.

I want to chart the data shown above in a bar chart using a dynamic named range which I have created, however the named range is including the "" values

How can I change this so the named range only includes the text values and not the "" values?

Thanks

[jeversf]

Any chance you could upload a sample file slash_gnr3k?