Thanks Jon . . .

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

Rich

"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Rich W." wrote in message
...
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" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Rich W." wrote in message
...
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!