Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2004
    Posts
    6

    Unanswered: Pivotchart Scaling by Code

    I am trying to set the xlValue scale on a pivotchart by code, does anyone know how to do this. The Excel equalvalent is;

    With ActiveChart()
    .Axes(xlValue).MinimumScale = 0
    .Axes(xlValue).MaximumScale = 100
    End With

    I am trying to do something like this with a sub form that is a pivotchart;

    dblMinScale = DMin("Lo", "dbo_Historical_Data", "Symbol ='" & Forms!Stock_Chart.Symbol & "' And _
    Dt > (Date - 90)
    dblMinScale = DMax("Hi", "dbo_Historical_Data", "Symbol ='" & Forms!Stock_Chart.Symbol & "' And _
    Dt > (Date - 90)
    With ActiveChart()
    .Axes(xlValue).MinimumScale = dblMinScale
    .Axes(xlValue).MaximumScale = dblMaxScale
    End With

    I would really appreciate your help.

    Tiger
    Last edited by tigerwoo78; 05-14-04 at 16:25.

Posting Permissions

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