+ Reply to Thread
Results 1 to 5 of 5

Keeping chart size constant

  1. #1
    Registered User
    Join Date
    09-01-2012
    Location
    West Midlands, UK
    MS-Off Ver
    Excel 2010
    Posts
    16

    Keeping chart size constant

    Hi,

    I have 11 charts that are created automatically when data is copied into a worksheet,each chart also has a table to show the data. a few of the charts are dynamic . The problem I have is that the charts are re-sizing according to how much data they display. Once the 11 charts are generated I save them as a pdf but have to keep resizing the charts manually. i tried a few options such as keeping chart size and not resizing according to table contents but cannot keep the chart sizes the same.

    Is there a way to keep the chart area the same size permanently regardless of what data it plots?

    Many many thanks if you can help.


  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Keeping chart size constant

    Hi
    when you say "created automatically" do you use a macro? if so, you should be able to set the size as part of the macro something like:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-01-2012
    Location
    West Midlands, UK
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Keeping chart size constant

    HI,

    Thanks for reply, the charts are alreay created with all data plotted from the table, the macro then runs to remove duplicates and this is when the chart size changes. I know i could have created the chart with the macro but tried this a few times but never got it how i wanted.

    As the chart already exsists and the macro just removes duplicates where should i put the code ?

    Many thanks

  4. #4
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Keeping chart size constant

    Hi
    I'm not sure why your chart sizes are changing, can you upload a copy of your workbook so i can take a look? (obviously remove or overwrite any confidential data).

    alternatively, if all the charts are supposed to be the same size, you could run a macro to resize them. This macro will set all charts on the active sheet to the same size:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-01-2012
    Location
    West Midlands, UK
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Keeping chart size constant

    Thanks Nicky,

    I will try this macro now and report back.

    Thanks

+ 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