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 cant find it in Excel 2007.

Thanks for any thoughts!

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!

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!

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!

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!

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

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Shane Devenshire" wrote in message
...
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" wrote in message
...
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!

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...
--
Cheers,
Shane Devenshire


"Jon Peltier" wrote:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Shane Devenshire" wrote in message
...
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" wrote in message
...
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!

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


"ShaneDevenshire" wrote in
message ...
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...
--
Cheers,
Shane Devenshire


"Jon Peltier" wrote:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Shane Devenshire" wrote in message
...
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" wrote in message
...
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!

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

This posting is provided "AS IS" with no warranties, and confers no rights.


"Rich W." wrote:

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 cant find it in Excel 2007.

Thanks for any thoughts!