Dynamic chart where zero values are not included

I am using the 'standard' dynamic range chart in Excel 2010 (thank you Jon and Deborah) . I am getting my data range through a formula which will sometimes bring in ranges, say, A - D, and sometimes ranges A- F. If there is no value in the last row/s I do not want them to populate the chart with zero values AND I do not want the names or spaces to appear in the horizontal axis.

I have a attached a sample and thanks for any ideas how to solve this.