+ Reply to Thread
Results 1 to 3 of 3

Change size of all elements of a graph at once

  1. #1
    Registered User
    Join Date
    01-18-2021
    Location
    EU
    MS-Off Ver
    2013
    Posts
    6

    Change size of all elements of a graph at once

    Hello!

    I apologize for the seemingly noobish problem, but I can't find an answer to that. How do I resize a chart while also changing the size of the elements of the chart? If I simply change the size of the graph, the various texts (title, axis titles, axis values) and elements (scatterplot plots) stay the same, it's simply the graph getting "stretched up". Is there a way to increase everything at once?

    Thanks in advance!

  2. #2
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: Change size of all elements of a graph at once

    I am not sure if I understand exactly but, in Chart Area Format pane, under size & properties you can find a check box named Lock aspect ratio
    Attachment 738608
    Diana Tanase


    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !

  3. #3
    Registered User
    Join Date
    01-18-2021
    Location
    EU
    MS-Off Ver
    2013
    Posts
    6

    Re: Change size of all elements of a graph at once

    Thanks for the answer!

    No, locking aspect ratio allows to keep the same horizontal/vertical ratio when changing size. It does not affect content of the graph. Texts within the graph with font size 10 will stay 10, even when doubling the size of the whole graph, that's my main problem.

+ 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. How to Change a graph size with VBA
    By dumbexcel55 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-21-2020, 08:31 AM
  2. Make donut graph remain same size regardless of chart title size?
    By mrbusto71 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-07-2019, 04:11 AM
  3. [SOLVED] Steering Wheel Chart Data Label Size. How do I change the size?
    By PhilHP in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-16-2018, 08:56 PM
  4. [SOLVED] Can I change Font size without changing cell size? Or confine row height change to one col
    By j_Southern in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-10-2018, 11:18 AM
  5. [SOLVED] Can I make a graph to be a specific size? (actual graph)
    By Jessica in forum Excel General
    Replies: 1
    Last Post: 11-17-2015, 10:43 AM
  6. Change font size keeping the cell size fixed
    By mayurpatil in forum Excel General
    Replies: 1
    Last Post: 07-09-2015, 01:52 PM
  7. Active-X elements changing size
    By Mark S in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2011, 06:20 AM

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