+ Reply to Thread
Results 1 to 4 of 4

Auto Scaling in charts

  1. #1
    JethroUK©
    Guest

    Auto Scaling in charts

    is there a method of clearing font scaling in charts by default (as opposed
    to chart-by-chart basis)



  2. #2
    John Mansfield
    Guest

    RE: Auto Scaling in charts

    Jethro,

    Can you let us know exactly what you mean by font scaling?

    If you're trying to shut off the primary Y-axis scaling, you could use a
    macro like this:

    Sub ShutOffScaling()
    Dim Sht As Worksheet
    Dim Cht As ChartObject
    For Each Sht In ActiveWorkbook.Sheets
    For Each Cht In Sht.ChartObjects
    With Cht.Chart.Axes(xlValue)
    .MinimumScaleIsAuto = False
    .MaximumScaleIsAuto = False
    .MinorUnitIsAuto = False
    .MajorUnitIsAuto = False
    End With
    Next Cht
    Next Sht
    End Sub

    ----
    Regards,
    John Mansfield
    http://www.pdbook.com

    "JethroUK©" wrote:

    > is there a method of clearing font scaling in charts by default (as opposed
    > to chart-by-chart basis)
    >
    >
    >


  3. #3
    Debra Dalgleish
    Guest

    Re: Auto Scaling in charts

    For new charts, you can change a registry setting to make "Off" the
    default. There are instructions in the following MSKB article:

    http://support.microsoft.com/default.aspx?id=168650

    Warning -- Back up your registry before you make any changes to it!!

    If you have Excel 2000, add a new DWORD (AutoChartFontScaling) with
    Value Data:0 to

    HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options

    For Excel 2002, add a new DWORD (AutoChartFontScaling) with Value Data:0 to

    HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options

    JethroUK© wrote:
    > is there a method of clearing font scaling in charts by default (as opposed
    > to chart-by-chart basis)
    >
    >



    --
    Debra Dalgleish
    Excel FAQ, Tips & Book List
    http://www.contextures.com/tiptech.html


  4. #4
    JethroUK©
    Guest

    Re: Auto Scaling in charts

    i dont have access to the registry (secured network) - thanx anyway for
    useful tip


    "Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in message
    news:41D99ABA.3050602@contexturesXSPAM.com...
    > For new charts, you can change a registry setting to make "Off" the
    > default. There are instructions in the following MSKB article:
    >
    > http://support.microsoft.com/default.aspx?id=168650
    >
    > Warning -- Back up your registry before you make any changes to it!!
    >
    > If you have Excel 2000, add a new DWORD (AutoChartFontScaling) with
    > Value Data:0 to
    >
    > HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options
    >
    > For Excel 2002, add a new DWORD (AutoChartFontScaling) with Value Data:0

    to
    >
    > HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options
    >
    > JethroUK© wrote:
    > > is there a method of clearing font scaling in charts by default (as

    opposed
    > > to chart-by-chart basis)
    > >
    > >

    >
    >
    > --
    > Debra Dalgleish
    > Excel FAQ, Tips & Book List
    > http://www.contextures.com/tiptech.html
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1