Excell 2010 Charting blank values with Auto Axis

I am trying to create a line chart with 3 data categories. The issue that I am having is that one of the data cats. only has part of the columns populated with data. I believe this is affecting how the auto Axis is calculating the min value (0). I would like to know if there is a work around, or something I can put in the blank cells so that the Auto Axis Min is calculated off the actual lowest inputed value and not the blank cell. I have attached a rough example of that I am talking about. Also, I do need the Auto Axis to remain on as I some data validation lists that change the data that is pulled into the chart, so fixed axis is not an option.

Thank you in advanced!