Autoscale fonts for charts in 2007

[Rich W.]

Is there a toggle that turns off the auto-scaling of fonts in a chart, for
2007?

My theory is that it was replaced by the "Character Spacing" tab. Did the
"autoscale" feature die an appropriate death?

It used to appear on the dialog for formatting fonts in the Chart Title,
Axis Labels, Legend, Axis scale, etc. I can’t find it in Excel 2007.

Thanks for any thoughts!

 

[Jon Peltier]

I thought I knew where that setting was, but now I can't find it. It's
confusing, since chart elements no longer have a font-related tab in their
format dialogs.

- Jon

 

[Rich W.]

Thanks Jon . . .

The only Help topic on "Autoscale" I'm finding is in "Change the display of
a 3-D chart", which doesn't seem to be it.

Although, I'm honored that you would reply to this post - I hit "Daily Dose
of Excel" from time-to-time.

Thanks again!

Rich

 

[Jon Peltier]

In VBA the command is AutoScaleFont. It must have been retained for
compatibility with Excel 2003 & prior. I applied it to a chart's chart area
in 2007, then experimented with resizing of the chart. It appears that the
font doesn't resize even with AutoScaleFont = True.

- Jon

 

[Rich W.]

Thanks Jon . . .

Like I told my user - he'll need to work with font sizes and character
spacing.

Rich

 

[Shane Devenshire]

Hi Jon,

You probably have seen the auto-scaling option which shows up for 3-D charts
under Chart Area, 3-D Rotation or Plot Area, 3-D Rotation.

Cheers,
Shane

 

[Jon Peltier]

Shane, Shane, Shane, haven't you been paying attention? I don't do 3D
charts.

- Jon

 

[ShaneDevenshire]

It was just a suggestion, I figured you might have noticed it in passing as
you explored 2007, maybe just to see what was new in that area.

Actually it seemed to me that you submitted a bug I discovered regarding 3D
charts when transfered from Excel 2003 to 2007. I had noted a legend problem
and related issues, and I thought it was you who wrote up my observations and
submitted it to the Charting group at Microsoft? I'm getting on in years
and, you know, they say the memory is the first thing to go.

And no I don't pay much attention to those sort of things...

 

[Jon Peltier]

I've heard that memory is the second thing to go, but I forget what's
first....

Proof of fading memory: I don't recall the item you're talking about, but I
also cannot rule it out.

- Jon

 

[Christopher Scott [MSFT]]

You are right, the auto scaling has been deprecated in Office 2007.