+ Reply to Thread
Results 1 to 7 of 7

Resizing Charts

  1. #1
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Resizing Charts

    Hi,

    I have 6 doughnut charts which I would like to have aligned
    I can set the outer hight and width in chart tools > format

    How to do I set the inner area so that are all the same size and position.
    They are only out a bit, but it annoys me, currently, I am doing it by eye!

    Thanks
    Kevin

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Resizing Charts

    You would need to use VBA code to precisely size and position the plot area within each chart.

    This will use the 1st chartobject and set the others to match.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Re: Resizing Charts

    Andy,

    Thank you very much, it worked great!
    Is it easily adaptable to align the position of the charts relative to this first?

    Thanks again
    Kevin

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Resizing Charts

    yes, use variant of following to move/size the chart objects

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Re: Resizing Charts

    Thanks Andy, but i am not quite sure what you mean.. i have very very limited knowledge of VBA

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Resizing Charts

    Rather than change properties of the chart you would change properties of the chart object.
    So the following with stack the charts below the 1st one

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Re: Resizing Charts

    Okay..Got it, thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Resizing Pivot Charts
    By dinesh_ltjd in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-18-2013, 08:47 AM
  2. Replies: 2
    Last Post: 03-03-2012, 06:40 PM
  3. Automatically resizing charts to align with the last row
    By brzpptp2 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-09-2010, 11:39 AM
  4. Resizing Line Charts using a Macro
    By emanon132501 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-22-2009, 09:29 AM
  5. resizing charts
    By cehs in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-10-2009, 02:30 PM
  6. Resizing pie charts
    By Masact in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-30-2009, 08:55 AM
  7. Resizing Charts
    By Andy in forum Excel General
    Replies: 1
    Last Post: 06-21-2006, 03:10 PM
  8. Resizing elements of Excel charts
    By Artifactual in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-30-2006, 11:25 PM

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