Prev: Graph colours
Next: Charting a variable range
From: Ted M H on 23 Jun 2008 12:11
Is there a way to tell Excel globally to uncheck the Auto scale checkbox on
the font tab for all chart elements? Or at least turn it off for all
elements on the current chart? The default seems to be to have auto scale on
and the only thing I can figure out to deal with it is to turn off each chart
element's auto scale, one at a time. For my situation this is truly an
obnoxious default setting.
From: Peter T on 23 Jun 2008 15:59
Try first unchecking font auto scale with the "Chart Area" selected (the
outside of the chart).

You could set your chart preferences as the default chart type, see Chart
types, Custom types, User defined.

Regards,
Peter T


"Ted M H" <TedMH(a)discussions.microsoft.com> wrote in message
news:C9102159-FD20-41FC-8666-7CC457E299AC(a)microsoft.com...
> Is there a way to tell Excel globally to uncheck the Auto scale checkbox
on
> the font tab for all chart elements? Or at least turn it off for all
> elements on the current chart? The default seems to be to have auto scale
on
> and the only thing I can figure out to deal with it is to turn off each
chart
> element's auto scale, one at a time. For my situation this is truly an
> obnoxious default setting.


From: Ted M H on 23 Jun 2008 16:13
Aha! So when you set the auto scale option for the chart area font, you set
it globally for the chart. That's great! Using the user defined charts,
including the default chart type, is also a helpful idea. Thanks very much
for your help.

"Peter T" wrote:

> Try first unchecking font auto scale with the "Chart Area" selected (the
> outside of the chart).
>
> You could set your chart preferences as the default chart type, see Chart
> types, Custom types, User defined.
>
> Regards,
> Peter T
>
>
> "Ted M H" <TedMH(a)discussions.microsoft.com> wrote in message
> news:C9102159-FD20-41FC-8666-7CC457E299AC(a)microsoft.com...
> > Is there a way to tell Excel globally to uncheck the Auto scale checkbox
> on
> > the font tab for all chart elements? Or at least turn it off for all
> > elements on the current chart? The default seems to be to have auto scale
> on
> > and the only thing I can figure out to deal with it is to turn off each
> chart
> > element's auto scale, one at a time. For my situation this is truly an
> > obnoxious default setting.
>
>
>
From: Jon Peltier on 23 Jun 2008 17:11
This tutorial shows how to uncheck the AutoScale box for all charts, going
forward (it doesn't fix any existing charts):

http://peltiertech.com/Excel/Charts/FixFonts.html

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


"Ted M H" <TedMH(a)discussions.microsoft.com> wrote in message
news:9D33240E-C005-4081-849E-72D7F17ED592(a)microsoft.com...
> Aha! So when you set the auto scale option for the chart area font, you
> set
> it globally for the chart. That's great! Using the user defined charts,
> including the default chart type, is also a helpful idea. Thanks very
> much
> for your help.
>
> "Peter T" wrote:
>
>> Try first unchecking font auto scale with the "Chart Area" selected (the
>> outside of the chart).
>>
>> You could set your chart preferences as the default chart type, see Chart
>> types, Custom types, User defined.
>>
>> Regards,
>> Peter T
>>
>>
>> "Ted M H" <TedMH(a)discussions.microsoft.com> wrote in message
>> news:C9102159-FD20-41FC-8666-7CC457E299AC(a)microsoft.com...
>> > Is there a way to tell Excel globally to uncheck the Auto scale
>> > checkbox
>> on
>> > the font tab for all chart elements? Or at least turn it off for all
>> > elements on the current chart? The default seems to be to have auto
>> > scale
>> on
>> > and the only thing I can figure out to deal with it is to turn off each
>> chart
>> > element's auto scale, one at a time. For my situation this is truly an
>> > obnoxious default setting.
>>
>>
>>


From: Ted M H on 23 Jun 2008 18:56
Hi Jon,

I thought your name sounded familiar...You're listed in a J. Walkenbach book
where he says you have "an uncanny ability to solve practically any chart
related problem." Indeed you do!

So this is a celebrity response! How cool is that? Very much appreciate
you sharing your expertise. Thanks.

"Jon Peltier" wrote:

> This tutorial shows how to uncheck the AutoScale box for all charts, going
> forward (it doesn't fix any existing charts):
>
> http://peltiertech.com/Excel/Charts/FixFonts.html
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
>
>
> "Ted M H" <TedMH(a)discussions.microsoft.com> wrote in message
> news:9D33240E-C005-4081-849E-72D7F17ED592(a)microsoft.com...
> > Aha! So when you set the auto scale option for the chart area font, you
> > set
> > it globally for the chart. That's great! Using the user defined charts,
> > including the default chart type, is also a helpful idea. Thanks very
> > much
> > for your help.
> >
> > "Peter T" wrote:
> >
> >> Try first unchecking font auto scale with the "Chart Area" selected (the
> >> outside of the chart).
> >>
> >> You could set your chart preferences as the default chart type, see Chart
> >> types, Custom types, User defined.
> >>
> >> Regards,
> >> Peter T
> >>
> >>
> >> "Ted M H" <TedMH(a)discussions.microsoft.com> wrote in message
> >> news:C9102159-FD20-41FC-8666-7CC457E299AC(a)microsoft.com...
> >> > Is there a way to tell Excel globally to uncheck the Auto scale
> >> > checkbox
> >> on
> >> > the font tab for all chart elements? Or at least turn it off for all
> >> > elements on the current chart? The default seems to be to have auto
> >> > scale
> >> on
> >> > and the only thing I can figure out to deal with it is to turn off each
> >> chart
> >> > element's auto scale, one at a time. For my situation this is truly an
> >> > obnoxious default setting.
> >>
> >>
> >>
>
>
>
 | 
Pages: 1
Prev: Graph colours
Next: Charting a variable range