Using Dynamic Ranges for Excel Charts

Hi,

I am want to create a dynamic chart which will get ignore the #NA values in the table and it should not plot them.
Refer to the attached excel file for more details.
I want a graph which will only displays the values for "Mars, Jupiter, Venus, Pluto" and ignore the #NA values.

Thanks