+ Reply to Thread
Results 1 to 4 of 4

Glue points no longer working on stacked and grouped shapes

  1. #1
    Registered User
    Join Date
    04-08-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    54

    Glue points no longer working on stacked and grouped shapes

    I am building a logic tree using shapes (text boxes) connected by arrows at glue points in Excel. Several of these boxes have multiple arrows coming in and out. The standard box only has 4 glue points and I found that it got confusing with multiple lines going to the same points.

    To get around this, I used 6 smaller boxes arranged 6x2, grouped them together, then placed the the text box over them and grouped everything together. This gives me 5 long side glue points and 3 on the short side. This was working well until I emailed the excel sheet and opened it on another computer. Now, the only glue points that are showing up are the 4 from the top shape. Any ideas on what happened? Also, any other ideas for workarounds? Thanks.

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Glue points no longer working on stacked and grouped shapes

    Are Excel versions identical on both computers?
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Registered User
    Join Date
    04-08-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Glue points no longer working on stacked and grouped shapes

    No after doing some more research I think it is just a change between the versions. The version the workbook was created in was 2010, the new one is 2016. Even if I "rebuild" my text boxes in the 2016 version, it still won't snap the the glue points behind. I've gotten around this by just putting the small boxes in front with no line and no fill. The only down side to this is when I need to change the color for a new box, I have to select and change each of the small boxes back to no line and no fill.

  4. #4
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Glue points no longer working on stacked and grouped shapes

    You could create a simple macro attached to a short-cut to achieve those repetitive tasks

+ 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. Replies: 1
    Last Post: 05-30-2013, 10:03 AM
  2. Grouped Shapes
    By treva31 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2010, 04:46 AM
  3. Bargraph with grouped and stacked bars?
    By FortuneSyn in forum Excel General
    Replies: 2
    Last Post: 01-27-2010, 08:33 AM
  4. Delete grouped shapes?
    By Dr.Ile in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2006, 06:00 AM
  5. [SOLVED] Assigning Macros to Grouped Shapes
    By Spinner in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-30-2005, 11:45 AM
  6. Names of Grouped Shapes
    By Mogwai in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-07-2005, 03:05 PM
  7. [SOLVED] Column Charts - stacked and grouped
    By jtd1 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-15-2005, 10:59 AM
  8. [SOLVED] How can I create a stacked bar chart with 3 bars grouped together.
    By SteW in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-05-2005, 06:06 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