• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

bVisual

  • Home
  • Services
    • How Visio smartness can help your business
    • Visio visual in Power BI
    • Visio Consulting Services
    • Visio Bureau Services
    • Visio Training and Support Services
  • Products
    • Visio Shape Report Converter
    • SS Plus
    • LayerManager
    • visViewer
    • Metro Icons
    • Rules Tools for Visio
    • The Visio 2010 Sessions App
    • Multi-Language Text for Visio
    • Document Imager for Visio
    • multiSelect for Visio
    • pdSelect for Visio
  • Case Studies
    • Case studies overview
    • Using Visio in Education for GIS
    • Visualizing Construction Project Schedules
    • Visio Online Business Process Mapping
    • Nexans Visio Template
    • CNEE Projects, WorldCom
    • Chase Manhattan Bank
  • News
    • Recent news
    • News archive
  • Resources
    • Articles➡
      • ShapeSheet Functions A-Z
      • Comparing Visio for the Web and Desktop
      • Customising Visio Shapes for the Web App
      • Key differences between the Visio desktop and web apps
      • Using the Visio Data Visualizer in Excel
      • Using Visio in Teams
      • Creating Visio Tabs and Apps for Teams with SharePoint Framework (SPFx)
      • Designing Power Automate Flows with Microsoft Visio
      • Innovative uses of Visio Lists
    • Webcasts ➡
      • Visio in Organizations
      • My session and other Visio sessions at MSIgnite 2019
      • Power up your Visio diagrams
      • Vision up your Visio diagrams
      • The Visio 2010 MVP Sessions
    • Visio Web Learning Resources
    • Books➡
      • Visualize Complex Processes with Microsoft Visio
      • Mastering Data Visualization with Microsoft Visio
      • Microsoft Visio Business Process Diagramming and Validation
      • Visualizing Information with Microsoft Visio
  • Blog
    • Browse blog articles
    • Visio Power BI articles
    • Visio for Web articles
    • A history of messaging and encryption
  • About us
    • About bVisual
    • Testimonials
    • Bio of David Parker
    • Contact Us
    • Website Privacy Policy
    • Website terms and conditions
    • Ariba Network
You are here: Home / Visio / Visio 2010 / Data Import & Export Features in Visio 2010

Published on May 24, 2011 by David Parker

Data Import & Export Features in Visio 2010

I have been using (Microsoft) Visio for importing and exporting data since 1996, and was an early tester/adopter of the Database Wizard features in Visio 4.1 (I think). I think of Visio as a data visualization tool, yet I cannot recall seeing a comprehensive list of the areas in Visio, out-of-the-box, where you can import and export data easily. So I decided to draw a data-linked diagram of just this for Visio 2010.

image



I have made the files available for you at the following links:

  • Visio file : https://1drv.ms/x/s!AqkzN8kb1lAz5EURpWctPZlFsCwl?e=PKVa0a
  • Excel workbook : https://1drv.ms/x/s!AqkzN8kb1lAz5EURpWctPZlFsCwl?e=PKVa0a
  • Saved as Web version : https://1drv.ms/u/s!AqkzN8kb1lAz5EnqDG1VP9MYf5Gm?e=PlMyxe
  • PDF version : https://1drv.ms/b/s!AqkzN8kb1lAz5ENiBi4SLIfc7r69?e=l23H1y
  • XPS version : https://1drv.ms/u/s!AqkzN8kb1lAz5ES1YX5Cr-7gUiWz?e=BagMPW

I built the diagram on data that I entered into an Excel workbook, although I soon realised that I could have perhaps done this better in Access or SQL Server!

I decided to split the data sources and targets into three different (product) types:

  • Desktop App
  • Server
  • File Format

Each of the data sources and targets are automatically color-coded, using Data Graphics, according to their type:

image

There is a legend at the bottom of the diagram too:

image

The source types of import data to Visio are arranged across the top of the diagram, and the target types of export data from Visio are arranged along the bottom.

The features in Visio that utilize data are grouped by their category across the middle of the diagram:

  • Business
  • Data
  • File / Save As
  • Maps and Floor Plans
  • Review
  • Schedule
  • View / Add-Ons / Visio Extras

Each of the Visio feature boxes contain a hyperlink that explains it in more detail.

image

The connectors between the data and the Visio feature are automatically color-coded too, according to the lowest edition of Visio where the feature is available.

image

Hopefully, you already realize that the Professional edition has all of Visio Standard, plus extra stuff. Similarly, Premium has all of Professional, and then adds more stuff, such as Visio Services and Data Validation.

image

What my diagram reveals is there are far more import data features than export data. This is a pity, but data updates should be done with caution, and perhaps should be identity controlled. For example, the Link Data to Shapes feature is only one way, though there are a few of us who use the connection information to create a two-way link in code.

I also used the Review / Shape Reports feature to export the relevant data to a table:

Product Links
CategoryFeatureFrom ProductTo ProductComments
BusinessBrainstormingVisio 2010 StandardExcel 2010 
BusinessBrainstormingVisio 2010 StandardWord 2010 
BusinessBrainstormingVisio 2010 StandardXML 
BusinessBrainstormingXMLVisio 2010 Standard 
BusinessOrganization ChartExcel 2010Visio 2010 Standard 
BusinessOrganization ChartExchange 2008 ServerVisio 2010 Standard 
BusinessOrganization ChartODBCVisio 2010 Standard 
BusinessOrganization ChartText FilesVisio 2010 Standard 
BusinessOrganization ChartVisio 2010 StandardExcel 2010 
BusinessOrganization ChartVisio 2010 StandardCSV Files 
BusinessOrganization ChartVisio 2010 StandardText Files 
BusinessPivot DiagramAccess 2010Visio 2010 Professional 
BusinessPivot DiagramExcel 2010Visio 2010 Professional 
BusinessPivot DiagramODBCVisio 2010 Professional 
BusinessPivot DiagramOLEDBVisio 2010 Professional 
BusinessPivot DiagramSharePoint 2010 Foundation ListVisio 2010 Professional 
BusinessPivot DiagramSQL Server 2008 Analysis ServicesVisio 2010 Professional 
BusinessPivot DiagramSQL Server 2008 DatabaseVisio 2010 Professional 
DataLink Data To ShapesAccess 2010Visio 2010 Professional 
DataLink Data To ShapesExcel 2010Visio 2010 Professional 
DataLink Data To ShapesODBCVisio 2010 Professional 
DataLink Data To ShapesOLEDBVisio 2010 Professional 
DataLink Data To ShapesSharePoint 2010 Foundation ListVisio 2010 Professional 
DataLink Data To ShapesSQL Server 2008 DatabaseVisio 2010 Professional 
DataLink Data To ShapesXMLVisio 2010 ProfessionalVia code only
DataSharePoint WorkflowVisio 2010 PremiumVWI 
DataSharePoint WorkflowVWIVisio 2010 Premium 
File / Save AsWeb PageVisio 2010 StandardXML 
Maps and Floor PlansImport DataExcel 2010Visio 2010 Professional 
Maps and Floor PlansImport DataExchange 2008 ServerVisio 2010 Professional 
Maps and Floor PlansSpace Plan Startup WizardExcel 2010Visio 2010 Professional 
ReviewShape ReportsVisio 2010 StandardHTML 
ReviewShape ReportsVisio 2010 StandardXML 
ReviewShape ReportsVisio 2010 StandardExcel 2010 
ScheduleCalendarOutlook 2010Visio 2010 Standard 
ScheduleGanttCSV FilesVisio 2010 Standard 
ScheduleGanttExcel 2010Visio 2010 Standard 
ScheduleGanttProject 2010 ProfessionalVisio 2010 Standard 
ScheduleGanttText FilesVisio 2010 Standard 
ScheduleGanttVisio 2010 StandardExcel 2010 
ScheduleGanttVisio 2010 StandardText Files 
ScheduleGanttVisio 2010 StandardProject 2010 Professional 
ScheduleTimelineProject 2010 StandardVisio 2010 Standard 
ScheduleTimelineVisio 2010 StandardProject 2010 Standard 
View / Add-Ons / Visio ExtrasDatabase Export WizardVisio 2010 StandardODBC 
View / Add-Ons / Visio ExtrasDatabase WizardODBCVisio 2010 Standard 
View / Add-Ons / Visio ExtrasExport to DatabaseVisio 2010 StandardODBC 
View / Add-Ons / Visio ExtrasLink to DatabaseODBCVisio 2010 Standard 

One pattern that I often need to use is consuming data from web services, and I would like to see this added to the next version of Visio, rather than having to always write the code myself.

Another common pattern that I would like to see is the automatic connection between shapes using a nominated data-linked connector … an extension to Link Data to Shapes. Whilst I am creating this wish list, I would also like to see the automatic placement of data-linked shapes into data-linked containers.  Both of these wishes were achieved manually in the attached diagram.

Related

Filed Under: External Data, Shape Data, Visio 2010 Tagged With: Data Export, Data Import

About David Parker

David Parker has 25 years' experience of providing data visualization solutions to companies around the globe. He is a Microsoft MVP and Visio expert.

Reader Interactions

Comments

  1. Rahul Gupta says

    July 6, 2011 at 6:32 am

    Hi,
    I am having issue with Visio while using the hyperlink when i generate the web page of the Visio file.
    I am using BPMN diagram in Visio 2010 & have 5 different Visio files, each having about 30+ processes documented.
    For illustration only:
    Let’s say, I have created 4 files:
    1st File “Plan”: which has following collapsed sub-processes: A–> B –> C?
    2nd File “Planning Activities – A”: which has following tasks: A1–> A2–>A3
    3rd File “Planning Activities – B”: which has following tasks: B1–> B2–>B3?
    4th File “Planning Activities – C”: which has following tasks: C1–> C2–>C3?
    I have linked collapsed sub-process “A” within 1st file with the sub-process worksheet saved in 2nd file to give a blown-up view of expanded sub-process “A”. Similarly I have done it for collapsed sub-process “B” as well as collapsed sub-process “C” in 1st file i.e. linked each to its blown-up view in other Visio 2010 file.

    Since 1st file is the parent file, I am trying to save that as web page (*.html).

    When i open the saved web page and click on the collapsed sub-process “A” it opens the Visio file for “Planning Activities – A”, instead it showing it on HTML so that I can view A1 on html and then navigate back to A-> B-> C diagram.

    Ideally, when I save as the parent file in html format, data from the entire downstream Visio file should also be saved as html content with configured hyperlinks.

    Appreciate if you can suggest a work around.

    Regards
    Rahul Gupta

    Reply
  2. Len says

    August 17, 2011 at 3:26 pm

    link to excel not working?

    Reply
    • davidjpp says

      September 2, 2011 at 7:26 am

      Sorry, I got the file extension wrong… fixed now.

      Reply
  3. elrod says

    October 28, 2011 at 9:09 am

    link to excel STILL not working

    Reply
    • davidjpp says

      October 31, 2011 at 7:36 am

      it SHOULD be working now …

      Reply
  4. Jillika says

    October 31, 2011 at 3:27 am

    hi,

    I am trying to create a diagram like the one you have shown as an example here. Could you post some helpful information on how you were able to create the diagram above? I am trying to work at it using the ‘link data to shapes’ feature and need to link to data from excel.
    Can you please help me out??I have tried to find steps to work it out everywhere online with no luck.
    Many thanks.

    Reply
  5. Jillika Iyer says

    November 1, 2011 at 3:25 am

    Hi,

    Could you please post snapshots or instructions on how you created the above diagram ?
    Any link where we could refer it would also be very useful.

    It would be very helpful.

    Thank you.

    Reply
    • davidjpp says

      November 8, 2011 at 2:41 pm

      Hopefully my other response will help?

      Reply
  6. Jillika Iyer says

    November 4, 2011 at 4:02 am

    hi

    I had one question based on the example you have worked out in your post.
    The visio diagram has 2 sheets:”To Product Links” and “From Product Links” while the excel provided has only 1 consolidated Product Link sheet.
    Could you tell me if you were able to sort out the sheet in visio itself (if so how??) or is it a different sheet you used while creating the visio diagram?

    Thank you

    Reply
    • davidjpp says

      November 8, 2011 at 2:40 pm

      I used the ProductLinks sheet as the source for both DataRecordsets, but used different filters in the Rows to Include / Select Rows… dialog.. I used a (custom) filter on the From Product and To Product fields, where they Contain the word Visio.
      You can examine the query that I used with the Immediate window … the lines that start with a ? are the commands I typed in, and the following line is the response:

      ?Visio.ActiveDocument.DataRecordsets(4).Name
      From Product Links

      ?Visio.ActiveDocument.DataRecordsets(3.Name
      To Product Links

      ?Visio.ActiveDocument.DataRecordsets(4).CommandString
      select * from `Product Links$` WHERE `From Product` LIKE ‘%Visio%’

      ?Visio.ActiveDocument.DataRecordsets(3).CommandString
      select * from `Product Links$` WHERE `To Product` LIKE ‘%Visio%’

      Reply
      • Jillika Iyer says

        November 9, 2011 at 3:18 am

        Hi David,

        Thank you for so much for the detailed information. This was the a very helpful blog with data I was searching for from a long time.
        I had one more question. I was trying to leverage the Web Drawing feature after creating my Visio Diagram by linking it to data from excel.
        Could you explain how we can publish the web drawing on shared sites like sharepoint?
        Can we do it in anyway without having the visio services enabled?
        Please let me know.
        Thank you again.

        Reply
        • davidjpp says

          November 23, 2011 at 9:04 am

          Visio Services gives you the ability to have a Visio drawing to be apparently updated when it is viewed in the Visio Web Drawing Share Point web part.
          These updates are restricted to Shape Data values and linked Data Graphics, it does not include addition, deletion or movement of any shapes.

          If you do not have Visio Services enabled then the Visio document will need to be opened in Visio to be refreshed before saving back to SharePoint (or re-publishing to any where else).

          Of course, if the refresh requires adds, deletes or moves then you would need to have the Visio drawing refreshed in Visio anyway.

          Reply
  7. Soala Bryce says

    November 23, 2011 at 4:17 am

    I’m trying to create a diagram which can update when the data is updated ie, the size of the shapes and color when the $amount is updated.

    Can you please help

    Reply
    • davidjpp says

      November 23, 2011 at 8:58 am

      Firstly, you can use DataGraphics to change the color, if you want, or you can use the ShapeSheet to chnage the Color and the Size

      If you have an Ellipse shape, then open the ShapeSheet (tick File / Options / Advanced / Developer Mode)
      Let’s say you have a Shape Data row called Prop.Amount, with a default value of 0, and you want the shape to have a minimum width of 4 mm, then enter the following formula in Width
      =GUARD(4 mm + (Prop.Amount * 0.1 mm))
      and in Height:
      =GUARD(Width)

      You can even make the Circle grow logrithmically, if a pure scalar growth is too much:
      =GUARD(4 mm+LOG10((Prop.Amount*1 mm)))

      You will now have a circle that grows and shrinks according to the Prop.Amount value.

      Similarly, you can have fun with the Color…
      Actually there are two Color cells, FillForegnd and FillBkgnd, and the FillPattern value controls which one is most dominant.
      If FillPattern = 1 (Solid), then only FillForegnd is shown, and Color can be expressed as RGB(n,n,n) where n is any number between 0 to 255.
      Therefore you could have a formula that plays with these numbers …
      For example, the following formula for FillForegnd would change the color from Red at $0 to Green at $1,000,000, going through all shades in between:
      =GUARD(RGB((255-INT((Prop.Amount/1000000)*255)),INT((Prop.Amount/1000000)*255),0))

      You would usually edit the Master shape to do this…

      Check out this old reference, it’s still useful : http://msdn.microsoft.com/en-us/library/aa245244(v=office.10).aspx

      Reply
  8. Bill says

    December 30, 2011 at 3:10 pm

    This is excellent. In playing around I tried to change in the ShapeSheet for a Product stencil object from Hyperlink_VisDM_Comparison>Description to the User.visEquivTitle. I saved it as a new Master stencil. No matter how many ways I’ve tried this when I link new data to the new Product object it reverts back to the description ‘Comparison.’ I’m guessing this is something to do with SETATREF behavior which is new to me. Even when i create a new master it will always revert back. Can you comment?

    Thanks again.

    Reply
    • davidjpp says

      January 31, 2012 at 11:57 am

      Have you tried http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=16086 ?

      Reply
  9. Steve says

    January 27, 2012 at 5:28 am

    Hi,
    I simply want to import source code into Visio Professional 2010 and create UML diagrams with it. From what I’m finding, it is either not possible, or very difficult. Is that the case, or have I missed something?

    Reply
    • davidjpp says

      January 31, 2012 at 11:49 am

      Do you get Project / Visio UML / Reverse Engineer option in Visual Studio 2010 ?

      Reply
  10. Jim C says

    January 30, 2012 at 9:08 pm

    David,
    I am very very green at visio and want to use this functionality linked to an access database.
    However I want to be able to automatically change connector start and end points when i change data in the data base. You had done something like this with org charts. Is there a clear detailed explanation on how to dynamically derive shapes and links for data in an access database?

    Reply
    • davidjpp says

      January 31, 2012 at 11:52 am

      Jim,
      Ah … I have been asking Microsoft to provide such functionality out-of-the-box. We used to have a Flow Chart Wizard and a Network Diagram Wizard that could create connected diagrams …
      I usually have an External Recordset that contains the from and to connections. I will look to see if I can generalise the code over the next few days….

      Reply
      • Jim C says

        January 31, 2012 at 1:49 pm

        Thank you appreciate any help you can give the newbie….

        Reply
  11. Thorsten says

    March 10, 2012 at 3:44 pm

    David,
    If I get it right you’ve used an Excel as source for this amazing visio. Where can I find it? With the link above I get a zip with several xml but no xlsx…
    I’m trying to define shapes and links outside visio and to generate a simple flowchart – like it was possible in earlier versions with csv.
    Can you help me?

    Reply
    • davidjpp says

      March 12, 2012 at 8:28 am

      I have listed the link to the Excel file in the blog : http://www.visualizinginformation.com/blog/OfficeProductLinks.xlsx

      Regarding automatically connecting shapes together from data: I too remember the old Network Diagram and Flow Chart Import Wizards that enabled connections to be created automatically from files. Sadly, we no longer have a similar feature, but I often have to automate this task. My approach is almost always the same, which is to use Link Data to Shapes to create linked external data recordsets. Then I write code to use this data to create connections. I have done this in my post at http://davidjpp.wordpress.com/2009/02/24/creating-an-org-chart-without-the-org-chart-wizard/ , for example.

      Reply
  12. Roy says

    August 9, 2012 at 7:53 am

    David,
    I use visio to make network diagrams, I searched the internet if it’s possible to export data to excel, for easy editing and then to import that data back to the drawing.
    I hope you can tell me if this is possible and were i can find it.

    Reply
    • davidjpp says

      August 10, 2012 at 8:40 pm

      The old Database Wizard stuff in Visio does allow two way communication with Excel, but it has some problems as it is based on the old ODBC toolkit.
      The newer Link Data to Shapes only reads from Excel.
      You can use the Shape Report feature to export data to Excel but the resultant worksheet is unlikely to be in the same format that you originally used to import using Link Data to Shapes. However, yu could feasibly write some code to reconcile the two.
      Another option is to write code to read the data recordset and connection settings used for Link Data to Shapes, and then modify it to become a writable link back to Excel. I have recently done this for a client, so it can be done.

      Reply
  13. Roy says

    August 13, 2012 at 9:10 pm

    I’m not familiar to writing code and i have got hundreds of drawings. Have you got an example for me. But If i read your explanation i think that it needs a lot of time.

    Reply
  14. Jan piet says

    March 5, 2013 at 9:57 pm

    Hi David,

    A very nice presentation of the feature set!

    I am having the problem in Visio 2010 that a background of a shape of the object itself is not able to be externally referenced, Is this option present in Visio 2013 html exports today?

    Here is a less cryptic and very simplified example; if the rectangle does not work, see it as an image itself.
    You have a visio file with 1 rectangle, the backround of the rectangle should be a image.jpg that is frequently (1 second) updated on the host server.
    by adding a refresh line in visio´s html code I was able to refresh the page but the problem is that I am not able to reference the image.jpg to the external location.
    Visio seems to export this image.jpg in its own format.

    Have you got experience with this or do you have any thoughts?

    br

    jp

    Reply
    • davidjpp says

      March 26, 2013 at 3:46 pm

      Hmm … it is not that Visio saves the png into a different format, it is that you cannot get at the particular image to refresh it directly.
      Perhaps you should look at injecting your own JavaScript functions into the exported html files?
      If your rectangle has any Shape Data or hyperlinks, then the export to html should create an image map or similar (depending on the output format you choose).
      There are JavaScript functions in the export to use these shapes in the search or mouse over vents, for example.

      Check out John Goldsmith’s blog at

      Reply
  15. StantheMan says

    June 27, 2013 at 4:47 pm

    Hi David.

    Will it be possible to take the data from a Visio 2010 Gantt Chart , ID, Tasks, Start and Finish to a relational database. I see you have mentioned that text files can be generated. I would like to use the info from the Gantt chart to create a table in a database.

    Appreciate the advice

    Reply
    • davidjpp says

      December 26, 2015 at 11:44 am

      All the Task Bar shapes have Shape Data, so you can use the Review \ Shape Reports task to export to Excel.
      The Dependencies\Link Lines would require some code to extract the connections

      Reply
  16. cricstar says

    July 30, 2013 at 6:47 am

    How to download selected callflows in to excel sheet in visio?
    i know we have shape reports option,but my issue is we cant download selected callflow pages
    the only options available are current pages and all pages.
    let me know if there is some thing else that might help me out.

    Reply
    • davidjpp says

      July 30, 2013 at 9:12 am

      I amnot sure if I understand your question, but does this help : http://blog.bvisual.net/2009/09/16/listing-connections-in-visio-2010/

      Reply
  17. george says

    August 15, 2013 at 8:26 am

    can I export visio symbols properties to csv file?

    Reply
    • davidjpp says

      August 15, 2013 at 10:01 am

      You can export to Excel, and from there save as csv

      Reply
  18. CAtherine says

    October 10, 2013 at 3:05 pm

    HI, Is this visio/excel file still available for download. I like what I see, but unable to download and not sure what is the problem. Thx

    Reply
    • davidjpp says

      March 26, 2014 at 3:46 pm

      Now fixed

      Reply
  19. E. Forrest Christian says

    March 5, 2014 at 2:44 pm

    For what it’s worth, visualizinginformation.com seems to be redirecting to sedoparking.com

    Reply
    • davidjpp says

      March 11, 2014 at 12:03 pm

      Thanks, link (visualizinginformation ) is now working again, with an improved site. All code can be downloaded from the Book Index page.

      Reply
  20. E. Forrest Christian says

    March 7, 2014 at 3:22 pm

    Your visualizinginformation domain seems to be down, obtw. It’s a great book, still useful.

    Reply
    • davidjpp says

      March 11, 2014 at 12:03 pm

      Thanks, link (visualizinginformation ) is now working again, with an improved site. All code can be downloaded from the Book Index page.

      Reply
  21. greg winterhalter says

    March 15, 2014 at 5:09 am

    I enjoyed this blog and it was helpful. The links above go to http://visiorules.com/visinfo/ instead of the files suggested. I would like to see them if you are willing. Thanks. Greg

    Reply
  22. Nuno says

    March 22, 2014 at 2:02 pm

    Hi David,
    Thanks for sharing!
    I’ve tried to download the files following the link on the top of the page but i’m re-direct to a page that doesn’t contain the files.

    thanks again,
    Nuno

    Reply
    • davidjpp says

      March 26, 2014 at 3:45 pm

      Should be fixed now.

      Reply
  23. Nuno says

    March 22, 2014 at 2:14 pm

    The (Download All Code.zip) don’t have the Product Links.xxx files

    Reply
    • davidjpp says

      March 26, 2014 at 3:44 pm

      I have fixed those links now.

      Reply
  24. remco says

    April 3, 2014 at 7:45 am

    Hello, i have the problem that:
    – i want to insert a number of visio processflows into word,
    – add hyperlinks to each specific process,
    – being able to use the hyperlinks in Word and PDF
    Using Word 2010, Visio 2013 Adobe 11 reader.
    The problem i have when i copy straight out of visio is that the word version doesnt let me check the hyperlinks since it opens visio.
    The problem i have when i save the visio object as .wms, than import it as an image and finally edit the image is that the hyperlinks can work in word, however not in adobe. However other hyperlinks in that same file do work.

    Reply
    • davidjpp says

      April 8, 2014 at 3:38 pm

      I am not sure I understand totally. Are you using Copy & Paste in Word, or Insert Object From File? Do you have a single hyperlink per Visio shape?

      Reply
  25. [email protected] says

    August 19, 2014 at 7:41 pm

    Hi David, I am trying to create a pivot diagram with the org chart structure, but it does not display the hierarchy. Are you able to help me with that?
    to be more especific, I need the sales summarized by manager, then rollup to VP, rolledup to Director and have the total also for the president. Is this feasible?

    Reply
    • davidjpp says

      August 29, 2014 at 4:10 pm

      I will soon have an article on Pivot Diagrams coming out on http://blog.orbussoftware.com/category/microsoft-visio/ , though I think your requirement is a little different and more like the summaries that I created in my first book : http://visiorules.com/visinfo/chapter.cshtml/3

      Reply
  26. Robert Holden says

    February 1, 2016 at 4:34 pm

    Do you have any examples or tips on generating Event-driven process maps from Excel data? I’m build “use cases” and have processes in mind, but I’m not familiar with setting up a UML diagram, and I don’t think they want that anyway. EPC seems more “shiny”, which plays better for our customer. Any help you can provide is greatly appreciated.

    Reply
    • davidjpp says

      July 15, 2016 at 3:43 pm

      My new book contains code examples for creating diagrams from data.

      Reply
  27. mikael bhar says

    July 22, 2021 at 9:29 am

    Hello,

    Your links are dead. Would be so kind to upload it or do you have other places where we can download it again?

    Best regards

    Reply
    • David Parker says

      July 22, 2021 at 9:52 am

      Hmm, sorry. Microsoft changed the personal OneDrive links protocol … I have updated the links now

      Reply

Trackbacks

  1. Does Adobe Acrobat make better PDF files from Visio? « bVisual says:
    August 1, 2012 at 11:11 am

    […] Top Posts Data Import & Export Features in Visio 2010 […]

    Reply
  2. Visio 2010′s Import and Export Features | The TPS Report from Trillium Professional Services says:
    April 6, 2013 at 7:14 pm

    […] I​f you’ve ever wondered whether Visio could be convinced, cajoled, or forced to play nicely with another application, then this blog post is for you: bVisual’s Data Import & Export Features in Visio 2010 […]

    Reply
  3. Data Import and Export Features in Visio 2016 (and 2013) | bVisual - for people interested in Microsoft Visio says:
    November 16, 2015 at 2:38 pm

    […] Data Import & Export Features in Visio 2010 […]

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

  • LinkedIn
  • Twitter

Recent Posts

  • Fixing dimensions of 2D shapes
  • Merging Linked Data from Similar Tables
  • Smart Radio Buttons and Check Boxes in Visio
  • Using Button Face Ids in Visio
  • Grid Snapping Revisited

Categories

Tags

Accessibility Add-Ins Connectors Containers Data Export Data Graphics Data Import Data Visualizer Educational Excel GraphDatabase Hyperlinks Icon Sets JavaScript LayerManager Layers Legend Link Data to Shapes Lists MSIgnite MVP Office365 Org Chart PowerApps PowerBI PowerQuery Processes Setup and Deployment Shape Data Shape Design ShapeSheet ShapeSheet Functions SharePoint 2013 SQL Teams Validation VBA Video Visio Visio 2007 Visio for the Web Visio Online Visio Services Visio Viewer Webinar

Footer

bVisual Profile

The UK-based independent Visio consultancy with a worldwide reach. We have over 25 years experience of providing data visualization solutions to companies around the globe.

Learn more about bVisual

  • Amazon
  • E-mail
  • Facebook
  • LinkedIn
  • Twitter
  • YouTube

Search this website

Recent posts

  • Fixing dimensions of 2D shapes
  • Merging Linked Data from Similar Tables
  • Smart Radio Buttons and Check Boxes in Visio
  • Using Button Face Ids in Visio
  • Grid Snapping Revisited

Copyright © 2025 · Executive Pro on Genesis Framework · WordPress · Log in