Hi,
Is there a way to make the x-axis labels of an Excel chart always be vertical (i.e. the label is "read" bottom to top)?

I have a chart with input data that changes. That results in the x-axis labels sometimes being vertical, slanted, or horizontal. I know that you can click and drag to change the width of the chart to get the desired effect, but is there a way to either 1) set it to be always vertical, or 2) have a piece of vba code that detects whether the slant direction of the data labels and automatically adjusts the chart width to achieve vertical data labels?

Thanks.