Results 1 to 2 of 2

Thread: Resize Chart in Proportion [RESOLVED]

Threaded View

  1. May 13th, 2004, 05:38 AM #1
    agmorgan
    agmorgan is offline

    Thread Starter
    Frenzied Member agmorgan's Avatar
    Join Date
    Dec 2000
    Location
    Lurking
    Posts
    1,383

    Resize Chart in Proportion [RESOLVED]

    Im having the same problem as this guy.
    http://www.vbforums.com/showthread.p...t=chart+resize

    I dont want my plot of a circle to change to an ellipse when I resize my chart.

    The code to do it in VBA is
    VB Code:
    1. ActiveSheet.Shapes("Chart 1").ScaleWidth 0.8, msoFalse, msoScaleFromTopLeft

    2. ActiveSheet.Shapes("Chart 1").ScaleHeight 0.88, msoFalse, msoScaleFromTopLeft
    This resizes by 0.8 and keeps the proportions.
    I got this by recording a macro whilst holding down shift and resizing.

    What I am trying to do, is have a worksheet event that ONLY allows proportional resizing.

    ie when I resize the chart, it always gives the effect of shift being held down at the same time
    Last edited by agmorgan; May 13th, 2004 at 09:54 AM.
    Help me with my PKR Hand History Tool
    AutoUpdater - ActiveX Control Format numbers to Significant Figures
    Delete Recent Projects from VB6 IDE Emulate Windows 95 Powertoys Regex in Excel
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width