none
How to insert a table in Visio 2010

    Question

  • Hi...

     

    I need to create a table in Visio 2010 that has 12 rows and 4 columns. I cant for the life of me see where and how I can accomplish this! Any help is greatly appreciated! :) 


    Thanks... Frank
    Monday, February 28, 2011 6:17 PM

Answers

  • Visio 2007 Professional contains a set of Grid table shapes that allow you to adjust the row and column count.  To access from the stencil menu path: Business -> Charts and Graphs -> Charting Shapes.

    If that's also in 2010, you may be good to go.


    Steve Mack
    • Marked as answer by ThePrep Tuesday, March 01, 2011 6:41 PM
    Monday, February 28, 2011 6:55 PM

All replies

  • Visio 2007 Professional contains a set of Grid table shapes that allow you to adjust the row and column count.  To access from the stencil menu path: Business -> Charts and Graphs -> Charting Shapes.

    If that's also in 2010, you may be good to go.


    Steve Mack
    • Marked as answer by ThePrep Tuesday, March 01, 2011 6:41 PM
    Monday, February 28, 2011 6:55 PM
  • Thanks Stephen!!! That worked perfectly :)
    Thanks... Frank
    Tuesday, March 01, 2011 6:41 PM
  • Insert an Excel Worksheet

    Use: Insert \ Object \ Microsoft Excel Worksheet

    This is the only way to do this without it being a kludge

    Thursday, February 09, 2012 7:20 PM
  • Those tables from charting shapes are horrible.

    Too bad Visio doesn't have a problem table create function, its not always handy to import from excel. If you have access to a Mac with omnigraffle has a nice table function though haha ;)

    Anyway I prefer it this way, to go Data -> Link Data to Shapes, this way have more control about what you import from the excel sheet and what not and easier to resize. 

    Thursday, April 19, 2012 2:25 PM
  • Yes, the Grid Control provided in "Charting Shapes" isn't very usable given it doesn't seem to resize properly when you adjust the number of rows/columns.

    I was hoping I could paste from Excel, but this doesn't seem to work.

    Any other ideas?

    Edit: I used Insert/Object Microsoft Excel Worksheet and it sort of works. 

    • Edited by Peter_D503 Thursday, April 26, 2012 1:18 AM Insert/Object
    • Proposed as answer by Alex Serafico Wednesday, April 24, 2013 3:05 PM
    • Unproposed as answer by Alex Serafico Wednesday, April 24, 2013 3:06 PM
    Thursday, April 26, 2012 1:13 AM
  • To insert a table in Visio Basic:

    • Create the table in Excel or Word
    • Copy the screen image to clipboard (Alt-Print Scrn)
    • Open Paint
    • Paste screen image into Paint
    • Crop the image to only the table.
    • Save cropped image as a .png file
    • Insert .png file as a picture in Visio.
    • Resize and place picture as needed within Visio

    Kinda roundabout method, but it works.

    mcgruk

    Monday, July 09, 2012 6:21 PM
  • Hello Peter,

    Regarding the Grid shape resizing problem - I wrote a blog post about this a while ago and it includes a download shape that solves the problem:

    http://visualsignals.typepad.co.uk/vislog/2012/02/modifying-the-visio-grid-shape.html

    http://visualsignals.typepad.co.uk/vislog/2012/03/building-visio-shapes-with-code.html

    Best regards

    John


    John Goldsmith (Visio MVP)
    http://visualsignals.typepad.co.uk/vislog/
    http://www.visualsignals.co.uk/

    Tuesday, July 10, 2012 7:38 AM
  • I've just been having the same problem and tried all the suggestions below but wasn't happy with the results, so I kept trying and found something that works for me:

    1. Copy a section of an Excel spreadsheet
    2. Right Click in your Visio drawing
    3. Select 'Paste Special' 
    4. Select 'Microsoft Excel Worksheet'
    5. Click OK and the copied cells are inserted.
    6. Double-Click inside the inserted cells and they open up in Excel format and behave just as though you are working in Excel, within Visio!
    7. Create you Table as you want it
    8. Double-Click outside the Table and it becomes part of the drawing again!

    Good Luck!

    John

    Tuesday, September 17, 2013 10:55 AM
  • nice one..
    Sunday, April 27, 2014 6:34 AM