Question: I Have created a bar chart in a 2007 .xls file, but the data labels cannot be resized. When you go to the "format Data Labels" and then click on alignment, the Autofit and Internal Margin option is grayed out. Anyone know why?

Answer: 
A way around it is to make the chart area big. The data label boxes will resize to fit the words in one line. Then make the chart small (not the chart area).

![enter image description here](https://i.stack.imgur.com/Qigch.png)
Manually insert a textbox into the bar chart and type in the label that way. It's annoying and labor-intensive, but it works.