Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-08-2022, 05:38 AM
phil_Solihull phil_Solihull is offline Importing swimlanes from excel ? Windows 11 Importing swimlanes from excel ? Office 2016
Novice
Importing swimlanes from excel ?
 
Join Date: Feb 2022
Posts: 2
phil_Solihull is on a distinguished road
Default Importing swimlanes from excel ?

I am new to vision so please forgive me if this is a daft question, some years ago I saw a guy complete a process map in Excel and import it into Visio, It did all the swim lanes and stuff
Can’t find the option to import in my current version of Visio?
Any ideas please guys
Reply With Quote
  #2  
Old 02-09-2022, 06:34 PM
Guessed's Avatar
Guessed Guessed is offline Importing swimlanes from excel ? Windows 10 Importing swimlanes from excel ? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Does this youtube video help? https://www.youtube.com/watch?v=Q6_vop2kHCg
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 02-10-2022, 10:38 AM
phil_Solihull phil_Solihull is offline Importing swimlanes from excel ? Windows 11 Importing swimlanes from excel ? Office 2016
Novice
Importing swimlanes from excel ?
 
Join Date: Feb 2022
Posts: 2
phil_Solihull is on a distinguished road
Default Files

my version of Vision does not seem to have the same templates as the video
Reply With Quote
  #4  
Old 02-10-2022, 08:47 PM
Guessed's Avatar
Guessed Guessed is offline Importing swimlanes from excel ? Windows 10 Importing swimlanes from excel ? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Maybe your version of Visio (like mine) doesn't include that template. See Create a Data Visualizer diagram which says
Quote:
The ability to use the Data Visualizer templates is only available with Visio Plan 2. If you're not sure what version of Visio you're using, select File > Account > About Visio. See Visio Plan 2 to learn more about the subscription version of Visio.
I'm sure it is possible to build a macro to give yourself the same functionality but it won't be a simple task.

I've created network diagrams and org charts from Excel using VBA in Visio and I can say that doing the same for cross-functional flow charts is do-able but not easy. It would certainly be more cost efficient to upgrade your Visio Plan than investing in the time needed to do it with VBA (unless you have many users who need the functionality).

If you know a bit about VBA, there are resources online which can get you started on a 'roll your own' vba solution. The first link might work for you right out of the box.
Create Visio Horizontal Swimlane from Excel ActiveSheet | MrExcel Message Board
Excel macro to create visio flow | MrExcel Message Board
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Swimlanes and Swimlane Titles Chris Waller Visio 0 05-16-2018 05:05 AM
Importing a Calendar from Excel pdaoud Project 0 12-14-2017 07:10 AM
How can I build a cross-functional flow chart showing two swimlanes sharing the same process? stud3 Visio 4 06-02-2016 02:17 AM
Importing swimlanes from excel ? Importing Excel rogertb Word 2 05-02-2014 11:53 PM
SmartArt Issue: Horizontal Hierarchy to connect across swimlanes cnyoon2 PowerPoint 1 02-10-2014 07:48 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:18 AM.


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