I'm getting pretty frustrated about the font size in my charts not autoscaling/sizing when I crop the chart. I hope someone can tell me where to find/how to turn on autoscale for fonts in a chart!
Looks like Microsoft did away with this feature when they went to 2007. If you have 2003 or earlier and still need to be able to toggle this, I'd recommend an add-in similar to this:
Then I'm afraid you're out of luck. Most people got annoyed at the AutoScaling feature and were constantly having to turn it off, which is why I think Microsoft removed it.