Hide X axis labels if its with a blank data

Hi,

Is there a way that I can hide the x axis label with blank data in Excel 2007. I am fully aware that I can manually exclude those ranges but that’s not the option I am looking for as I am preparing a dynamic chart which automatically gives me a graphical report. The Dates from 13-Aug onwards which is blank needs to be hidden, doing so I will free up that space for the remaining bars to become wider.


Thanks in advance.