none
How to insert a table in Visio 2010

    質問

  • 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
    2011年2月28日 18:17

回答

  • 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
    • 回答としてマーク ThePrep 2011年3月1日 18:41
    2011年2月28日 18:55

すべての返信

  • 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
    • 回答としてマーク ThePrep 2011年3月1日 18:41
    2011年2月28日 18:55
  • Thanks Stephen!!! That worked perfectly :)
    Thanks... Frank
    2011年3月1日 18:41
  • Insert an Excel Worksheet

    Use: Insert \ Object \ Microsoft Excel Worksheet

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

    2012年2月9日 19:20
  • 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. 

    2012年4月19日 14:25
  • 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. 

    • 編集済み Peter_D503 2012年4月26日 1:18 Insert/Object
    • 回答の候補に設定 Alex Serafico 2013年4月24日 15:05
    • 回答の候補の設定解除 Alex Serafico 2013年4月24日 15:06
    2012年4月26日 1:13
  • 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

    2012年7月9日 18:21
  • 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/

    2012年7月10日 7:38
  • 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

    2013年9月17日 10:55
  • nice one..
    2014年4月27日 6:34
  • This works great in any Visio version

    1. Open Power Point with a blank slide.

    2. Copy Excel Grids / Cells

    3. Paste in Power point slide . It creates a Table.

    4. Copy the Power point Table

    5. Paste in VISIO.... WOW....!!

    Regards

    Udhay

    2014年9月6日 6:20