• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Visio Guy

Smart graphics for visual people




  • Home
  • Hire Me
    • Hire Me
    • Résumé
  • Products
    • Products
    • Bubble Revision Shape
    • Layers to Pages Utility
    • Rack Unit Dimension Line
    • Radial Elements Tool with up to 100 Wedges
    • Text on a Circle Visio SmartShape
  • Index
    • Articles by Date
    • YouTube – VisioGuy
    • Download Information
    • Suggestion Box
    • Shop
    • Visio Art
    • Visio Links
    • – Visio Shapes & Stencils
    • – Visio Templates & Drawings
  • About
    • About
    • Donate
    • GitHub
    • jsFiddle
    • Reading List
    • Subscribe & Follow
      • – E-mail
      • – facebook
      • – Twitter
      • – RSS
    • Privacy Policy
  • Discussion Forum
You are here: Home / Visio Content / Drawings / “Follow the Money” Visio Sankey Diagram

“Follow the Money” Visio Sankey Diagram

October 26, 2009 By Visio Guy 12 Comments

Follow the Money Sankey Diagram ThumbIf you love Sankey Diagrams like me, you’ll be interested in how one Visio Guy reader created a very sophisticated flow using simple techniques.

He did it all in Visio, and the result is pretty impressive!

Visguy reader Chris Webb works for the Woodland Trust, which “is the UK’s leading woodland conservation charity”. He wanted to show people in the Trust what systems were being used for receiving specific types of income.

The result of Chris’ hard work is this attractive specimen:

Follow the Money Sankey Diagram

click to view larger image

This tale is a bit of a data-visualization success story. The brownish-red colored stream represents the income that goes through the CRM system. Once the diagram was finished, Chris showed it to fellow employees. It surprised a number of people here and helped them to focus on it’s importance. Chalk one up for diagrams-as-valuable-tools!

Chris didn’t use any of the fancy Sankey diagram shapes that we’ve talked about and shared on this web site. Instead, he made clever use of line thicknesses to create the diagram.

Here we can see that the “Sponsorship” flow has an ample line-thickness of 30pt.:

sankey-flow-thickness

The biggest flow in the diagram is the “Direct Marketing” flow, which has a whopping 146pt line-weight!

By simply using the Format > Line dialog to make flows thicker and thinner, he could then use lines of any shape, including the smooth, flowing curves that you see in the diagram. I like the gentle curves in this diagram, and he a very nice use of color to distinguish different families of flow, yet still make an attractive diagram.

In contrast, shapes like those in Pre-wired Sankey Diagram Shapes, are (still) very limited in their geometry: they only do “straight arrow”. But, they have outlines, support gradient fills, have user-specified head and tail shapes, and are data-driven to some extent:

As usual, with Visio there are several ways to get the job done. So if you need fancy formatting and black outlines, then maybe the straight, Visio Guy shapes will work just fine. But if you need flowing curves, then Chris’ line-thickness technique is definitely the way to go!

Download “Follow the Money Sankey Diagram”

s!Aj0wJuswNyXlhnviAzkDvrmT9SBN – Downloaded 7947 times – 103.00 B
The Woodland Trust is the UK’s leading woodland conservation charity.
  • Tweet
  • More
  • Pocket
  • Share on Tumblr
  • Print
  • Email

No related posts.

Filed Under: Drawings, Sankey Diagrams Tagged With: Custom, Custom Line Patterns, Custom Patterns

Previous Post: « Choose Colors with Shape Data Fields
Next Post: Calculate Work Weeks For Your Visio Shapes »

Reader Interactions

Comments

  1. Mark Nelson says

    October 29, 2009 at 7:59 am

    Great visuals! This is a pretty good way to get a fluid Sankey diagram. It gets me thinking about new ways to make this easier. Just thinking out loud, I wonder if this technique can be combined with the new List capability in Visio 2010 to good effect. Perhaps a Visio Guy reader will beat me to the working example.

  2. Marco says

    March 15, 2010 at 3:13 pm

    Wow, this was excactly what I was looking for. Didn’t know about sankey diagrams before.
    Chris, many thanks for the time and effort put into this diagram!
    Marco

  3. Raphael says

    April 30, 2010 at 9:17 pm

    Really impressive work! It needs a lot of patience to do this! I really like the design and colors used.

  4. Egide says

    October 7, 2010 at 4:38 pm

    Just love it
    Egide

  5. Chris Webb says

    October 16, 2010 at 9:37 pm

    I am very glad this has gone down well with some. The thing that’s missing for me is any real feel for the direction of flow. We all know it’s left to right, but it’s not indicated in the diagram. To make this work for more complex flows (circuits) I have found that copying and pasting a thick line on top of itself and then formatting the top version to be a ‘wire-frame’ style arrow works pretty well. It breaks down when the lines get too narrow.

  6. Jon says

    November 6, 2010 at 10:10 am

    Thanks for a great example of making complex data simple.

    Wouldn’t it be great if you could use something like this to report from a database – there’s something intrinsically understandable about this diagram that would take many more bar, pie and flow charts to acheive.

  7. STHBRDG says

    September 29, 2011 at 6:09 am

    This really looks nice! In regards to the Left to right flow, I noticed that if you turn on the “end point” arrows, they point leftward in some instances. The shapeText also points right to left. The only reason that I mention it is that the Wingdings font provides some arrow shapes as text characters. If you scale the text size to fit the line and set the transparency/ select the correct font shade, then they aren’t that big of a distraction and portray the linkage and flow that you are talking about.

    If you mix the methods associated with text along connector shapes, then you can direct the arrow with the same curve of the Sankey line which looks nice.

    FYI, there are many arrows, but I found Wingdings #240 to be suitable.

    Does anyone think that there is merit to the concept of a glue contour line that has connections points at strategic locations for each Sankey line to make an attachment? I’ve read some of the randomization blogs and with some Bezzier curves and some math, you could achieve a fluid connection boundary. The contour would also serve as a nice point to justify/angle the text associated with the line.

  8. Rob says

    July 16, 2014 at 4:12 pm

    Hi Visio Guy,

    I just uploaded a brand new online Sankey Builder. Upload data, configure via a wide range of tools and save. It allows you to drag and drop fields from your data to customize the Sankey Flow and dynamically add Filters on any Field in the diagram to squeeze the data. Has automatic highlights of bands across the diagram to highlight data relationships and you can even mix and match colors. Automatic Paging for large data sets! A Sort feature by value or field in ascending order. All settings can be saved for a future visit. The tool includes a Share feature which allows you to enable or disable any of the settings. The unique URL created by the tool allows you to distribute the Sankey Diagram to visitors for a read-only interactive version of Sankey Builder! Check out the demo (see below). You can even build a Free Sankey Diagram which is hosted for free. Simply visit HeatMap.ca and signup (all you need is an email address). That will get you access to SankeyBuilder for free. Demo: http://sankeybuilder.com/sankeybuilder.aspx?url=bbe34d97f8 and Tutorials are at http://sankeybuilder.com

    Let me know what you think?

    Rob

  9. JonSnow says

    July 25, 2014 at 8:06 pm

    Thank you so much.

  10. Dan Spinney says

    January 28, 2019 at 6:42 pm

    Hi Visio Guy – love your work – I know it’s been a while since this thread was live, but it seems the download links for the Pre-wired Sankey Diagram Shapes and the “Follow the Money” Visio Sankey Diagram don’t seem to work – could you get them working again? Many thanks!

Leave a Reply Cancel reply

Primary Sidebar

Buy Über Rack Unit Dimension Line
Article — Purchase

Categories

Buy my book!

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Tag Cloud

A/V Artistic Effects BPM Code Connectors Control Handles Countries Custom Patterns Custom Properties Data Graphics Data Linking Data Visualization David Edson David Parker Fill Format Formulas Functions Geometry Gradient Images Links Maps Multi-shapes Network Programming repeating shapes Resources Right-Click Actions Scale Shape Data ShapeSheet ShapeSheet Formulas ShapeSheet Functions SharePoint shiny SmartShapes Sport Sports Text Themes Tools Transparency User-defined Cells Visio 2007 Visio SmartShapes

Top Posts & Pages

  • - Visio Shapes & Stencils
  • - Visio Templates & Drawings
  • Sankey Diagram Shapes for Visio
  • Bubble Revision Shapes
  • Dynamic Updating Org Charts in Visio!
  • Text Along a Connector's Path in Microsoft Visio 2010
  • Amazon AWS Visio Shapes
  • Visio Network Server Shape Icon Customization Tool
  • Go 3D with Free Isometric Piping Shapes for Visio
  • Audio Visual Components Shapes

www.visguy.com - Visio Guy - since 2006

 

Loading Comments...