Author Topic: New Videos on e!Sankey Live Link to Excel  (Read 1501 times)

Offline pbeilschmidt

  • Administrator
  • Hero Member
  • *****
  • Posts: 532
  • e!Sankey - show the flow.
    • Umberto - know the flow.
New Videos on e!Sankey Live Link to Excel
« on: June 28, 2018, 03:14 PM »
Two new videos have been uploaded to the e!Sankey You Tube Channel, that might be of interest.

Using e!Sankey Live Links to Microsoft Excel | Part 1 (10 mins)
This video shows how to set the Live Link reference and update a Sankey diagram with values from Excel

Using e!Sankey Live Links to Microsoft Excel | Part 2 (5 mins)
This video explains how the Live Link can be combined with advanced functions in Excel (here: INDIRECT) to switch between datasets (e.g. annual energy data)

Enjoy!
« Last Edit: July 30, 2018, 02:49 PM by pbeilschmidt »
Peter Müller-Beilschmidt
e!Sankey Forum Moderator
ifu Hamburg GmbH

Offline pbeilschmidt

  • Administrator
  • Hero Member
  • *****
  • Posts: 532
  • e!Sankey - show the flow.
    • Umberto - know the flow.
Re: New Videos on e!Sankey Live Link to Excel
« Reply #1 on: July 30, 2018, 03:00 PM »
And two more videos have been added:

e!Sankey 4 | Process properties: shapes, icons, images  (2 mins)
Learn how to change the default process property symbol in a Sankey diagram. Use different shapes, fill colors, an icon from the clipart gallery or a photo. Quite a funny sample diagram ('Paul's pet costs').

e!Sankey 4 | How to avoid overlapping arrows  (3 mins)
In this video learn how to avoid overlapping arrows and gaps between arrows running parallely. Sample diagram shows imports and exports to/from the United States broken down in product groups.
Peter Müller-Beilschmidt
e!Sankey Forum Moderator
ifu Hamburg GmbH

Offline Scholten

  • Newbie
  • *
  • Posts: 1
Re: New Videos on e!Sankey Live Link to Excel
« Reply #2 on: September 19, 2018, 12:15 PM »
Will there be more videos like these, Peter? I think they're a great resource.