+ Reply to Thread
Results 1 to 5 of 5

Alignment problems when making a flowchart

  1. #1
    Registered User
    Join Date
    05-23-2013
    Location
    Brasschaat, Belgium
    MS-Off Ver
    Excel 2010
    Posts
    8

    Alignment problems when making a flowchart

    When I make a flowchart in Excel I have difficulties getting the figures at the exact same heigth so as to make straight arrows when connecting them. I know there is an option you can select that kind of divides your sheet into a series of equally sized grids (if it is not 100% clear, I am not talking about the standard Excel view) where for example if you would move one of the figures with the mouse it would move a set distance (say, half a grid) rather than some distance on an continuous line.

    I'm looking for this option, but I can't seem to find it. Thank you very much for your help!

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

    Re: Alignment problems when making a flowchart

    Have you tried the Alignment options?

    Drawing tools > Format > Arrange > Align.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Alignment problems when making a flowchart

    Not sure about a 'snap to grid' view, which you seem to describe... (Maybe Format > Arrange?)

    But you know you can specify precise shape dimensions, in the Size properties of the Format ribbon tab? You can also select multiple shapes and align them (top, left etc), to make sure they are all positioned evenly.

    Hope that is some help.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  4. #4
    Registered User
    Join Date
    05-23-2013
    Location
    Brasschaat, Belgium
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Alignment problems when making a flowchart

    This might be a solution to the specific problem I presented in the original post, but it is not what I am looking for. I am creating a timeline and I would like to be able to play around with the sizes of my shapes so that they visually correspond to an amount of time passed. Doing this in a continuous system correctly is very frustrating. To make it clear, in standard Excel in an area of 4x4 grids you have nearly infinite slightly different areas to place a shape. There is a function where you would move the shapes in discrete steps, which allows for maybe 20 different ways to position a shape in a 4x4 grid area.

  5. #5
    Registered User
    Join Date
    05-23-2013
    Location
    Brasschaat, Belgium
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Alignment problems when making a flowchart

    Yes snap to grid that's it! It is under drawing tools --> align so I guess you were both right. Thank you I did not see the function because I didn't have any shapes on my sheet yet.

+ 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. PDF Publish - Alignment problems with pictures from page 2
    By JompaBoy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2013, 02:09 AM
  2. problems making any changes in Excel
    By swmshelp in forum Excel General
    Replies: 1
    Last Post: 03-31-2011, 11:39 AM
  3. Problems With Header Alignment When Grouping
    By sliilvia in forum Excel General
    Replies: 0
    Last Post: 07-10-2008, 04:21 AM
  4. alignment problems when copying excel graphs to word
    By petevang in forum Excel General
    Replies: 2
    Last Post: 11-23-2005, 06:10 PM
  5. Replies: 3
    Last Post: 01-13-2005, 03:06 PM

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