+ Reply to Thread
Results 1 to 5 of 5

How can I reduce Chart Area without resizing Plot Area of a graph?

  1. #1
    Registered User
    Join Date
    10-30-2023
    Location
    Honduras
    MS-Off Ver
    2021
    Posts
    27

    How can I reduce Chart Area without resizing Plot Area of a graph?

    Hello, I have a situation that maybe you could help me with:
    I have this graph to which I'm trying to reduce the height and width of the chart area because I want to reposition it very near the top border of the worksheet, and the size of the chart area does not allow me go further up, when I try to resize the chart area, the plot area also resizes with it. i've tried many ways and bibliography about this question haven't helped me yet. Is there a way to reduce the chart area without affecting the size of the plot area? Maybe a VBA code that could help.

    I'm sending an image to illustrate what I mean and also a file with the graph with the problem.

    Many thanks for this.

    Untitled-2.jpg
    Attached Files Attached Files

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

    Re: How can I reduce Chart Area without resizing Plot Area of a graph?

    You have to use code if you want full control over the plot area.

    There is no ui to set the left/width/top/height, like there is for chart area.
    If you select the plot area you can use the mouse to adjust position and size.

    The plot area is always resized when the chart area changes.

    With your specific chart there is a lot of white space above the chart that you will not be able to shrink.
    If you select the plotarea you will see the bound area this occupies.

    General rule, if you want plot area to occupy maximum space is to adjust the plot area to fill as much of the chart area as possible and then adjust chart area.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    09-03-2016
    Location
    Catania, Italy
    MS-Off Ver
    Excel 2019
    Posts
    180

    Re: How can I reduce Chart Area without resizing Plot Area of a graph?

    HI
    After AndyPope's excellent explanations I add:

    Try enlarging the plot area to the maximum size of the Graph area.
    Then adjust (reduce) the Scale of the graph width to where you need it.
    In your case, after resizing the plot area, reduce the Graph Width Scale percentage to 67 and see if that's what you're trying to achieve.

    Attached is what I did with your graph.
    HI,
    Mario
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    10-30-2023
    Location
    Honduras
    MS-Off Ver
    2021
    Posts
    27

    Re: How can I reduce Chart Area without resizing Plot Area of a graph?

    Thank you for your explanation AndyPope, maybe Excel does something about this in the future.

  5. #5
    Registered User
    Join Date
    10-30-2023
    Location
    Honduras
    MS-Off Ver
    2021
    Posts
    27

    Re: How can I reduce Chart Area without resizing Plot Area of a graph?

    Thank you Marius44, actually what you did is much better from what I had. Thanks again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Resizing chart plot area
    By ubludkisranye in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2021, 12:16 PM
  2. [SOLVED] How to increase chart area without affecting plot area?
    By joeu2004@hotmail.com in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-05-2016, 11:26 AM
  3. Finding chart area or plot area
    By rlkerr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-25-2014, 04:35 PM
  4. Replies: 0
    Last Post: 08-19-2013, 06:22 PM
  5. [SOLVED] Resize plot area in a chart area
    By Darlene in forum Excel General
    Replies: 0
    Last Post: 07-10-2006, 09:54 AM
  6. [SOLVED] Resize chart area without resizing plot area
    By Janwillem van Dijk in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-01-2005, 09:05 PM
  7. Resize chart area without resizing plot area
    By Janwillem van Dijk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2005, 09:05 PM

Tags for this Thread

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