+ Reply to Thread
Results 1 to 1 of 1

Changing graph sizes/positioning and formatting over multiple worksheets at the same time

  1. #1
    Registered User
    Join Date
    03-07-2019
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    1

    Changing graph sizes/positioning and formatting over multiple worksheets at the same time

    Hi,

    I'm creating a dashboard for work, and I'm going to have multiple worksheets that need to look identical with text and graph positioning and fonts etc. The look of the worksheets is likely to change multiple times over the next few months, and I also find it very difficult to position graphs (generated from different data) at the exact same position without VBA, so I need something that I can apply across all of them. I'm not at all opposed to using/learning VBA for this, but I'm hesitant to do that until I know I need to, since everything I've thought I'd need to use VBA for thus far has ended up being much simpler without it and I've burned time by trying to do something too sophisticated. I'm just starting to learn excel obviously, but I did a CS major so I'm guessing learning the VBA for this won't take too long.

    My ideal is to simply be able to make changes on one worksheet which will include cell sizes, font sizes, graph sizes and positioning, and then do something quickly to apply all those changes to 4 more worksheets. I'm open to any suggestions and willing to learn for it, I suspect I've missed something obvious since this seems like a super simple concept but I haven't been able to find anything yet.

    Thanks in advance
    Last edited by fat_bob123; 03-07-2019 at 11:23 PM.

+ 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. Paste Formulas without changing relative positioning
    By letsExcelebrate in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2017, 07:03 PM
  2. X axis scale and multiple graph sizes
    By tashlana1 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-01-2016, 02:42 PM
  3. Changing formatting of one part of X axis on graph
    By ashveena in forum Excel General
    Replies: 2
    Last Post: 04-09-2015, 04:09 AM
  4. Changing multiple column graph sizes all at one go
    By ACrossley1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-27-2014, 04:57 AM
  5. Positioning Graph Axis Titles
    By psg8802 in forum Excel General
    Replies: 1
    Last Post: 04-22-2011, 11:04 AM
  6. Replies: 0
    Last Post: 12-09-2008, 08:42 PM
  7. Replies: 2
    Last Post: 09-18-2008, 04:02 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