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! :) 

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.

Thanks Stephen!!! That worked perfectly :)

Insert an Excel Worksheet

Use: Insert \ Object \ Microsoft Excel Worksheet

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

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. 

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

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

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

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

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

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

• Proposed as answer by twelve345 Tuesday, December 16, 2014 10:21 PM

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

• Proposed as answer by twelve345 Tuesday, December 16, 2014 10:21 PM

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

• Proposed as answer by twelve345 Tuesday, December 16, 2014 10:21 PM

nice one..

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

This works for Visio 2013 (not sure of 2010). In Word, copy your table to the clipboard. In Visio, choose (from the ribbon) Insert > Object > Microsoft Word Document and then paste the content from the clipboard. You now have an editable Word object with in Visio which you can format.

Thanks so much Ian, your method works perfectly!!