Consulting

Results 1 to 5 of 5

Thread: Plot Area Resizing

  1. #1

    Plot Area Resizing

    Hello John,

    I have been working with many PPT 2016 bar charts and column charts.
    I'm trying to keep the plot area size the same, but it always comes back to me in different sizes.

    Similar to the solution given by you in the below thread, can we copy the plot area size of one chart and apply it to another.
    http://www.vbaexpress.com/forum/show...9&goto=newpost


    Thanks & Best Regards,

  2. #2
    VBAX Master
    Joined
    Feb 2007
    Posts
    2,093
    Location
    Do you mean the plot area or the size of the whole chart.
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

  3. #3
    Hi John,

    Did a small change to the code you gave me last time and it worked out well (added .Chart.PlotArea).

    With ActiveWindow.Selection.ShapeRange(1).Chart.PlotArea

    Thanks much

  4. #4
    VBAX Master
    Joined
    Feb 2007
    Posts
    2,093
    Location
    Glad it worked but be aware that changing the plot area size can cause problems if you for example move the legend from bottom to left or right.
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

  5. #5
    Okay, I will make note of it.

    Thanks again

Posting Permissions

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