I have a chart where I only want to show one name in the x-axis labels. I made a helper column with just the desired label and blanks in the rest of the cells. However, the names have different lengths so the height of the label area changes each time and the plot area gets stretched or shrunk. Is there a way to keep a constant height of the plot/label area size while changing which x-axis labels are visible?

There is no way I can find to control label area size in VBA. I thought maybe I could change the color of certain labels to match the background but I don't think that is possible. I tried messing around with padding but couldn't find a system that consistently worked.