+ Reply to Thread
Results 1 to 3 of 3

Changing Chart Size in VBA

  1. #1
    Registered User
    Join Date
    06-14-2011
    Location
    New York, USA
    MS-Off Ver
    Excel 2003
    Posts
    24

    Changing Chart Size in VBA

    Hey guys,
    I'm using Analysis ToolPak VBA to create a histogram... but the histogram shows up really small! How can I change the size of the chart that outputs in my coding?

    Any help is much appreciated!

    Please Login or Register  to view this content.
    Last edited by awan0126; 07-21-2011 at 04:19 PM.

  2. #2
    Spammer
    Join Date
    01-26-2010
    Location
    Worcester MA
    MS-Off Ver
    Excel 2003
    Posts
    184

    Re: Changing Chart Size in VBA

    If you delete a range that has a chart floating over it, you will not delete the chart, just make it zero pixels wide. You may have dozens of these charts.

    Here's your code, with stuff I've added underlined and stuff you might be able to remove in italics. Color coding would have been nicer, but it doesn't work inside of code blocks.

    Please Login or Register  to view this content.
    Last edited by Jon_Peltier; 07-21-2011 at 04:09 PM.
    Jon Peltier
    http://PeltierTech.com/

  3. #3
    Registered User
    Join Date
    06-14-2011
    Location
    New York, USA
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: Changing Chart Size in VBA

    Thank you so much Jon! Really appreciate the help! This works great-- and learned something new

+ 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