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.