#1
|
|||
|
|||
New Data Source for each page in Visio
Hi everyone,
I have an Excel spreadsheet with a different sheet for each stage of a process. It was much easier to be able to focus on each stage on its own rather than all in the one process map as it makes changing the links to steps a lot simpler if we need to update a process. But I want to have a similar set up in Visio, where each page in Visio relates to a separate stage/sheet in my excel process map. Making the charts a lot simpler to follow and acutally readable. Plus I have added the option to click to go to the next process based on the outcome of the previous process as I need this interactive for staff and if they're too complicated no one will use it. I have copied & pasted the charts I'd done individually into one Visio document which is exactly what I want, but I can't refresh the data in that document to show changes. Is there a way to set a new data source for each page in a Visio document? I don't want to have to copy & paste each time if I can help it. Thank you! |
#2
|
||||
|
||||
I assume this question is talking about the data handling which is present in Visio Professional. Unfortunately I only have Standard so I don't have access to an embedded database to test.
I would presume you need all the data in a single worksheet to import and have it include a field used to filter each page's dataset. In since I have Visio Standard, I would need to write a macro to build the graphics dynamically - and possibly run that macro from Excel to create the file. Maybe someone with Visio Professional will chip in here but we don't have many Visio experts on this forum. Have you tried any Visio-specific forums?
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#3
|
|||
|
|||
Yes Visio Professional. I'm sorry, I thought this was for Visio. I googled 'visio forum' and this is what came up. I'll keep looking as you're the only reply to date.
Thank you |
Tags |
data source, pages |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Visio 2016 New homemade Shape Data export with Network Shape Data | Karlderxte | Visio | 1 | 08-17-2021 04:04 PM |
Adding new data to data source for Letter | emk_24 | Mail Merge | 4 | 11-27-2019 05:29 PM |
MS Visio 2013 vertically centre data in a shape after deleting all other data | Belachenko123 | Visio | 1 | 11-24-2015 09:42 AM |
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 | bobznkazoo | Excel | 2 | 03-27-2014 11:14 AM |
Edit Data Source- Linking template charts to new data | lbf | PowerPoint | 0 | 10-28-2011 12:19 PM |