VBA Chart Blank Values in Cell Range

I have a chart that is generated with a macro for a range of cells. At times some blank cells will exist within that range. I'm facing a problem when generating my chart with an empty cell value, the chart will start plotting at the first non empty cell, causing the category axis to not be reporting correct. How can I make my chart show a blank value on my chart using VBA. I would prefer not to use a formula on my cell range.

Here is my code:

Please Login or Register  to view this content.

What happens if you change this line...

Please Login or Register  to view this content.