ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Autoshapes and connectors (https://www.excelbanter.com/excel-discussion-misc-queries/83973-autoshapes-connectors.html)

tonywig

Autoshapes and connectors
 

I am trying to create a diagram which contains autoshapes with text
within them taken from cells on the worksheet.
Collecting the text works OK.
I am trying to add connectors between the autoshapes (this is similar
to a PERT chart if that helps describe it).
The connectors "connect" OK but after I've added more than a handful
they "disconnect". This means that when I move an autoshape the
connector does not move with it.

Anyone come across this and sorted out what the problem is.

If it helps ...
Excel 2000 9.0.6926 SP-3 on Windows 2000.

Much obliged for any help.


--
tonywig


------------------------------------------------------------------------
tonywig's Profile: http://www.excelforum.com/member.php...o&userid=18985
View this thread: http://www.excelforum.com/showthread...hreadid=534181


BruceP

Autoshapes and connectors
 

If I'm correctly understanding your question, simply grouping the
objects and connectors should take care of this issue.

Hold down <SHIFT and click on all the objects and connectors you want
to move at the same time. Once they're all selected, right click one
of the objects, select Grouping... and Group.

Hope this helps.

Bruce


--
BruceP
------------------------------------------------------------------------
BruceP's Profile: http://www.excelforum.com/member.php...o&userid=33653
View this thread: http://www.excelforum.com/showthread...hreadid=534181



All times are GMT +1. The time now is 11:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com