Hide data labels on the x-axis that represent value of 0 (i.e. remove empty space)

[lionlunatication]

Hi all,

I am trying to automate the removal of empty spaces in an existing bar chart (or data labels on the x-axis that have values of 0). Basically, the chart depicts each week of the year, and as the weeks progress, data is brought down to 0 for these weeks. How does one come about hiding these empty labels via VBA? Appreciate the help.

[lionlunatication]

Just realized the easiest way to do so is to search for empty columns in the range selected for the chart and get them hidden. Any ideas how one can do this though?