+ Reply to Thread
Results 1 to 2 of 2

Changing multiple column graph sizes all at one go

  1. #1
    Forum Contributor
    Join Date
    06-19-2013
    Location
    United Kingdom
    MS-Off Ver
    365
    Posts
    167

    Changing multiple column graph sizes all at one go

    Hi,

    I have hundreds of column graphs, how do I quickly change the size of them to the exact same size of 8.1cm height and 26.4cm width.

    Thanks.

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

    Re: Changing multiple column graph sizes all at one go

    If you are referring to the chart object size then you can use the selection pane, F10, to select multiple objects. And then use the ribbon Drawing Tools > Format > Sizes.

    But is the size is internal to the chart object then code would be needed
    Cheers
    Andy
    www.andypope.info

+ 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. Matching a column of shaft sizes to a column of hole sizes to find best match for all
    By BrettRCourtney in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-09-2013, 11:25 AM
  2. Changing the .PlotOrder of a column graph
    By kym1901 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-24-2010, 04:48 PM
  3. Replies: 0
    Last Post: 12-09-2008, 08:42 PM
  4. Changing column colours on a bar graph
    By cricket_stoner in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-17-2008, 06:01 AM
  5. Finding suitable graph sizes
    By Aelyn in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-18-2006, 10:48 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