Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-15-2013, 01:14 AM
eNGiNe eNGiNe is offline connectors between cells in pasted Excel table Windows 7 32bit connectors between cells in pasted Excel table Office 2010 64bit
Expert
connectors between cells in pasted Excel table
 
Join Date: Jan 2012
Location: Brussels [BE]
Posts: 746
eNGiNe is on a distinguished road
Default connectors between cells in pasted Excel table


I've inherited a .doc I need to update – add some content, save out as .docx for a grateful posterity.

The first screenshot shows what I started from: it looks as though individual tables have been placed in a graphics frame and connectors drawn in by hand.

The second shows as far as I've got with a more integrated approach, drawing all the tables in a single Excel sheet … but then I have absolutely no idea how to add connectors in a single layer :-{

Hints and tips welcome.
Attached Images
File Type: png wordTableWithConnectors.png (41.9 KB, 12 views)
File Type: png wordTableNoConnectors.png (21.5 KB, 10 views)
Reply With Quote
  #2  
Old 10-15-2013, 10:41 PM
macropod's Avatar
macropod macropod is offline connectors between cells in pasted Excel table Windows 7 32bit connectors between cells in pasted Excel table Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi eNGiNe,

Both images look to me like they're Word tables, not Excel worksheets embedded in a Word document. If you embed an Excel worksheet in your document, the connectors can be inserted directly into that, in which case they become (and remain) part of the embedded object's layer.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-16-2013, 03:01 AM
eNGiNe eNGiNe is offline connectors between cells in pasted Excel table Windows 7 32bit connectors between cells in pasted Excel table Office 2010 64bit
Expert
connectors between cells in pasted Excel table
 
Join Date: Jan 2012
Location: Brussels [BE]
Posts: 746
eNGiNe is on a distinguished road
Default

You're right, of course: it's not an embedded Excel table, just a copy/paste. What I still don't know is:
  • where to get hold of the drawing tools in 2010
  • whether I can draw on top of a table
Reply With Quote
  #4  
Old 10-16-2013, 04:23 AM
JimP JimP is offline connectors between cells in pasted Excel table Windows 7 32bit connectors between cells in pasted Excel table Office 2010 32bit
Experienced User
 
Join Date: Jun 2010
Location: Virginia Beach, VA
Posts: 742
JimP will become famous soon enough
Default

Quote:
Originally Posted by eNGiNe View Post
What I still don't know is:
  • where to get hold of the drawing tools in 2010
  • whether I can draw on top of a table
JMO but, I believe the drawing tools used are from PowerPoint (or similar software) just by the way they are drawn. One clue is the first arrow (top/left) where the arrowhead goes behind the table (the arrowhead is cropped off just a bit). There are other indicatiors of that as well if you look real close (looks like none of the arrow lines are "one continuous line"...they are multiple lines placed together to appear as one line). I am not aware of any drawing tools in Word 2010.
Reply With Quote
  #5  
Old 10-16-2013, 04:43 AM
macropod's Avatar
macropod macropod is offline connectors between cells in pasted Excel table Windows 7 32bit connectors between cells in pasted Excel table Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by eNGiNe View Post
What I still don't know is:
  • where to get hold of the drawing tools in 2010
Have you had a look at Insert|Shape?


Quote:
Originally Posted by eNGiNe View Post
  • whether I can draw on top of a table
Yes, you can.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 10-16-2013, 04:46 AM
JimP JimP is offline connectors between cells in pasted Excel table Windows 7 32bit connectors between cells in pasted Excel table Office 2010 32bit
Experienced User
 
Join Date: Jun 2010
Location: Virginia Beach, VA
Posts: 742
JimP will become famous soon enough
Default

Quote:
Originally Posted by macropod View Post
Have you had a look at Insert|Shape?


Yes, you can.
I stand corrected! Thanks Paul...
Reply With Quote
  #7  
Old 10-16-2013, 11:21 PM
eNGiNe eNGiNe is offline connectors between cells in pasted Excel table Windows 7 32bit connectors between cells in pasted Excel table Office 2010 64bit
Expert
connectors between cells in pasted Excel table
 
Join Date: Jan 2012
Location: Brussels [BE]
Posts: 746
eNGiNe is on a distinguished road
Default

"Shapes – insert ready-made shapes" says the tool-tip. I need to draw polylines, but even the F1 help says "no results found for polyline." What next?

[some minutes late] Ah, my mistake for using grown-up terminology … a web-search turned up the keyword "freeform". Unfortunately, I can't persuade either Freeform or Scribble to draw straight lines: I've tried holding down Shift before I draw, after I draw, while I'm drawing. All very frustrating! Hints and tips welcome.
Reply With Quote
  #8  
Old 10-16-2013, 11:58 PM
macropod's Avatar
macropod macropod is offline connectors between cells in pasted Excel table Windows 7 32bit connectors between cells in pasted Excel table Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You should see:
Attached Images
File Type: jpg Shapes.jpg (25.3 KB, 9 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
connectors, drawing tools

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Locked connectors Ulodesk PowerPoint 1 10-01-2013 03:59 AM
update one embedded excel table based on another excel table ajetrumpet Word 0 07-05-2013 08:51 PM
Eliminating borders on pasted excel graphs Marl PowerPoint 3 01-17-2013 06:32 AM
In Excel 2007-After Selecting Visibe Cells-How do I "Copy to Visible cells" Only mag Excel 0 10-28-2012 08:04 PM
connectors between cells in pasted Excel table U turn arrow, connectors, UML jvh24521 PowerPoint 2 09-02-2012 03:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:39 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft